Menampilkan Data Dari Beberapa TABEL Di (ORACLE)

Salah satu fitur SQL yang paling berguna adalah kemampuan untuk mengabungkan tabel – tabel dan mendapatkan data dari tabel tabel tersebut. Namun untuk mempelajari ini terlebih dahulu anda harus memahami tabel relasional dan rancangan database relasional.

Umum penggunaan

SELECT  table1.column, table2.column
FROM   table1, table2
WHERE  table1.column1 = table2.column2 

Contoh Penggunaan :

SELECT Employees.Last_Name, Employees.Job_Id, Jobs.Job_Title, Jobs.Min_Salary FROM Employees, Jobs WHERE Jobs.Job_id=Employees.Job_id AND Last_Name LIKE '%e'

SELECT Departments.Department_Id, Departments.Department_Name, Departments.Location_Id, Locations.Street_Address, Locations.Postal_Code, Locations.City FROM Departments, Locations WHERE Departments.Location_Id=Locations.Location_Id AND Department_Id BETWEEN 50 AND 100

SELECT Locations.Location_id, Locations.Street_Address, Locations.City, Countries.Country_Name FROM Locations, Countries WHERE Locations.Country_Id=Countries.Country_id AND Location_Id>=1500 AND City LIKE 'S%'

SELECT Locations.Location_id, Locations.Street_Address, Locations.City, Countries.Country_Name FROM Locations, Countries WHERE Locations.Country_Id=Countries.Country_id AND Location_Id>=1500 AND City LIKE '%S'

SELECT Countries.Country_Name, Countries.Region_Id, Regions.Region_Name FROM Countries, Regions WHERE Countries.Region_Id=Regions.Region_Id AND Region_Name='Asia' 

Tweet

Postingan terkait:

Ditulis Unknown — Tuesday 13 September 2016 — Add Comment — ORACLE