slect upit problem

[ 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!!!

[ Raspucin @ 21.02.2009. 23:17 ] @

Code:

SELECT
    c.FirstName,
    i.Make
FROM
    Customers c,
    Inventory i,
    Orders o
WHERE
    c.CustID = o.CustID AND
    o.CarID = i.CarID AND
    o.OrderID=0