[SOLVED] Can someone Help with this query??

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
jamesloi
Forum Newbie
Posts: 15
Joined: Thu Jul 15, 2004 5:11 am
Location: London

[SOLVED] Can someone Help with this query??

Post 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)
Last edited by jamesloi on Thu Jul 29, 2004 11:52 am, edited 1 time in total.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Code: Select all

SELECT * FROM Supplier INNER JOIN Booking USING( Supplier_ID ) WHERE Booking.REF = '$reference'
may work..
jamesloi
Forum Newbie
Posts: 15
Joined: Thu Jul 15, 2004 5:11 am
Location: London

Post by jamesloi »

8) thankyou
Post Reply