[RESOLVED] Select query - not in array

[sabien]

I'm running PHP4.3.11 and MySQL 5.0

I've got 2 tables: one called Events (holding all Event IDs) and one called Working (holding only active Event IDs).

I need to select information from the Events table where the EventIDs are NOT found in the Working table.

I can get the Working.EventIDs into an array, but how do I select against the unknowns?

i.e. "SELECT eventName FROM Events WHERE eventId NOT IN ($myArray)"

This "NOT IN" syntax is not correct, obviously, but it represents what I am trying to do - show the Events that need to be assigned.

Am I thinking down the wrong path here?

I also tried nested queries to cycle through the array, but it always turned up empty.

Any help is appreciated.

[sabien]

Found solution in "NOT IN (SELECT " syntax. Thanks.