Where Statements

Hi There

I have a table of trips in a schedule, The trip will consist of an outward and a return.

both records will look like this

ScheduleID|Time|TripId|PuAddress|DoAddress

I would like to be able to select schedule items where EITHER The PuAddress OR DoAddress matches my search

The only way i can think to do it is by using a union to to grab both side of the trip

SELECT * FROM trips where PUaddress = "address"
UNION
SELECT * FROM trips where DOaddress = "address"


My gut feeling is there has to be an easier way??

Ian

You should use single quotes for strings in SQL.