Tugas (3)
10.17 Edit This 0 Comments »
Query :
Result :
Apa maksud dari query di bawah ini ?
Result :
SELECT Products.CategoryID, Products.ProductName, Products.SupplierID, Products.QuantityPerUnit, Products.UnitPrice, Products.UnitsInStock, Products.UnitsOnOrder, Products.ReorderLevel, Products.Discontinued
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
WHERE (((Products.Discontinued)<>No))
ORDER BY Products.CategoryID, Products.ProductName;
FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID
WHERE (((Products.Discontinued)<>No))
ORDER BY Products.CategoryID, Products.ProductName;
Result :
Apa maksud dari query di bawah ini ?
SELECT Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry, Customers.CompanyName, Customers.Address, Customers.City, Customers.Region, Customers.PostalCode, Customers.Country
FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
Result :
Menampilkan isi field yang terdapat pada tabel Orders dan Customers, serta terdapat relationship diantara kedua tabel tersebut yang menghubungkan antara field CustomerID yang terdapat pada tabel Customers dengan field CustomerID yang terdapat pada tabel Orders
0 komentar:
Posting Komentar