Page 1 of 1

[SOLVED] Can someone Help with this query??

Posted: Thu Jul 29, 2004 11:10 am
by jamesloi
SELECT * FROM Supplier WHERE Booking.Supplier_ID = Supplier.Supplier_ID AND Booking.REF = '$reference'

Im trying to do this query but i am hopeless at SQL... I think u will be able to understand it.

can someon help me fix it.

Thanks 8)

Posted: Thu Jul 29, 2004 11:26 am
by feyd

Code: Select all

SELECT * FROM Supplier INNER JOIN Booking USING( Supplier_ID ) WHERE Booking.REF = '$reference'
may work..

Posted: Thu Jul 29, 2004 11:52 am
by jamesloi
8) thankyou