Sintak Sql2.docx

SELECT FirstName, LastName, Address,(year(now())-year(BirthDate)) as Age FROM Employees ORDER BY BirthDate; SELECT FirstName, LastName FROM Employees WHERE City="London";

Innerjoy = memenuhi dua duanya SELECT LastName, Orders.* FROM Employees,Orders; SELECT LastName, Orders.* FROM Employees,Orders WHERE Employees.EmployeeID=Orders.EmployeeID; SELECT LastName, Customers.* FROM Employees,Customers WHERE Employees.EmployeeID=Customers.EmployeeID;

SELECT * FROM ms_produk, tr_penjualan, target_penjualan WHERE ms_produk.kode_produk = tr_penjualan.kode_produk AND ms_produk.kode_produk = target_penjualan.kode_produk