imam 3 tabele
Code:
Customers
CustID
FirstName
LastName
Inventory
CarID
Make
PetName
Orders
OrderID
CarID
CustID
Customers
CustID
FirstName
LastName
Inventory
CarID
Make
PetName
Orders
OrderID
CarID
CustID
hocu da uradim select iz Customers i Inventory:
Code:
SELECT c.FirstName, i.Make
FROM Customers c, Inventory i
WHERE (c.CustID, i.CarID)
IN ( SELECT CustID, CarID
FROM Orders
WHERE OrderID=0)
SELECT c.FirstName, i.Make
FROM Customers c, Inventory i
WHERE (c.CustID, i.CarID)
IN ( SELECT CustID, CarID
FROM Orders
WHERE OrderID=0)
kao rezultat dobijam gresku u WHERE....
a hteo bih za zapis u tabeli Orders:
Code:
OrderID CarID CustID
-----------------------
0 1 3
OrderID CarID CustID
-----------------------
0 1 3
da dobijem odgovarajuci zapis iz Inventory (za CarID=1) i Customers (za CustID=3)???
u cemu gresim???
upit mi je potreban da kasnije popunim tabelu u DataGridView(C#)
hvala unapred!!!
DrekavaC