slect upit problem

Odgovori Nova tema

2 odgovora
2.537 pregleda

slect upit problem 21.02.2009. u 22:16 · pre 215 meseci #1

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

Potpis

DrekavaC

Re: slect upit problem 21.02.2009. u 23:17 · pre 215 meseci #2

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

Re: slect upit problem 22.02.2009. u 00:47 · pre 215 meseci #3

Radi! Hvala!!!!!!!

Potpis

DrekavaC

Prijavite se da biste odgovorili u ovoj temi.Prijava Registracija

Srodne teme