[RESOLVED] multiple table query help

[twitch]

Just when I start celebrating the fact that I'm getting the hang of multiple table queries, I stall on one for a several hours again...haha

I am trying to determine if a venue has open tables on a certain date or not. Each venue can have several tables.

The query below gives me an error: #1241 - Operand should contain 1 column(s)

SELECT *
FROM
  venues
INNER JOIN venue_tables ON (venues.venueID = venue_tables.venueID)
  INNER JOIN cities ON (venues.cityID = cities.cityID)
  INNER JOIN states ON (venues.stateID = states.stateID)
  INNER JOIN price ON (venues.priceID = price.priceID)
WHERE venues.cityID='74' AND venue_tables.tableID NOT IN (SELECT * FROM reservations WHERE reservationDate = '2010-11-26') GROUP BY venue_tables.tableID ORDER BY venueName ASC

I simply want to return a list of venues that have an open table on a certain date. I've hard coded the query for testing purposes.

Any help would be greatly appreciated. I'm sure I'm missing something simple.

Thanks in advance,
Twitch

[Bjom]

did you check whether your subquery returns a value?

this one:

SELECT * FROM reservations WHERE reservationDate = '2010-11-26'

[Lars_Berg]

use a specific column in the reservations table

venue_tables.tableID NOT IN (SELECT * FROM reservations)

The code tries to compare one column in venue_tables with multiple columns in reservations, which is not possible.

[twitch]

Hey Guys, thanks so much for the fast replies. For whatever reason I didn't get the notifications and decided to just check and see if anyone replied so sorry for the delay in responding on my part.

Much appreciated for sure. I have been battling with this query since last night. Lars nailed it. It needed a specific column in the second select column.

Thank you again guys.

-Twitch