[ drekavac007 @ 21.02.2009. 22:16 ] @
Pozdrav, imam 3 tabele Code: 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) kao rezultat dobijam gresku u WHERE.... a hteo bih za zapis u tabeli Orders: Code: 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!!! |