SQL INNER JOIN Keyword

The INNER JOIN keyword returns rows when there is at least one match in both tables.

SQL INNER JOIN Syntax

SELECT column_name(s) FROM table_name1 INNER JOIN table_name2 ON table_name1.column_name=table_name2.column_name

PS: INNER JOIN is the same as JOIN.

SQL LEFT JOIN Keyword

The LEFT JOIN keyword returns all rows from the left table (table_name1), even if there are no matches in the right table (table_name2).

SQL LEFT JOIN Syntax

SELECT column_name(s) FROM table_name1 LEFT JOIN table_name2 ON table_name1.column_name=table_name2.column_name

PS: In some databases LEFT JOIN is called LEFT OUTER JOIN.

SQL RIGHT JOIN Keyword

The RIGHT JOIN keyword returns all the rows from the right table (table_name2), even if there are no matches in the left table (table_name1).

SQL RIGHT JOIN Syntax

SELECT column_name(s) FROM table_name1 RIGHT JOIN table_name2 ON table_name1.column_name=table_name2.column_name

PS: In some databases RIGHT JOIN is called RIGHT OUTER JOIN.

LITERATUR. BY w3schools.com

Rumah Sakit Umum Prof Dr Aloei Saboe Gorontalo

Rumah sakit umum Prof Dr Aloei Saboe Gorontalo merupakan salah satu Pusat Layanan Kesehatan di kota Gorontalo yang menyediakan fasilitas dengan peralatan lengkap dan professional, Rumah sakit umum Prof Dr Aloei Saboe Gorontalo siap melayani para pasien dengan handal dan maksimal. Rumah Sakit ini memiliki Entitas yaitu Dokter,Perawat,Pasien,dan Ruangan.

Entitas dan Atribut

Tabel Matriks

Diagram Relationship