okay i'm trying to get some information out of my db all with only one query.. i'm trying to do a simple join but it's not returning any info.. the query is below...
QUERY:
select calendar.startDate, calendar.endDate, calendar.startTime, calendar.endTime, calendar.event_name, calendar.description, calendar.price, calendar.masterID, calendar.web, calendar.venueid, venue.name, venue.address, venue.city, venue.state, venue.zip, venue.phone, venue.url, venue.last_updated, state.abbreviation from calendar, venue, state where calendar.id = 55 and venue.id = calendar.venueid and venue.state = state.id
if you need any more information as regards to what i'm trying to do let me know and i'll put it here...
thanks for any help!
Jay
QUERY:
select calendar.startDate, calendar.endDate, calendar.startTime, calendar.endTime, calendar.event_name, calendar.description, calendar.price, calendar.masterID, calendar.web, calendar.venueid, venue.name, venue.address, venue.city, venue.state, venue.zip, venue.phone, venue.url, venue.last_updated, state.abbreviation from calendar, venue, state where calendar.id = 55 and venue.id = calendar.venueid and venue.state = state.id
if you need any more information as regards to what i'm trying to do let me know and i'll put it here...
thanks for any help!
Jay