What's wrong with this SQL query?

[bgowland]

Code:

SELECT oid, RECORDING_SCHEDULE.capture_source_oid, status FROM RECORDING_SCHEDULE WHERE status=0 AND capture_source_oid IN (SELECT capture_source_oid FROM BDA_RECORDING_SOURCE)

It only returns records for the first BDA capture_source_oid (I have 3). I orginally had a query with an INNER JOIN on the BDA_RECORDING_SOURCE table and it behaved exactly the same. I need all pending recordings for all my BDA devices but not my analogue devices. For the life of me I can't see what's missing.

Cheers,
Brian

[psycik]

Did you try right join or left join in your previous query? They may help

Failing that you may want to do it the hard way (query the bda_recording_source, then run queries for each recording source).

[bgowland]

Thanks - it's OK, I found the problem. I looked in a mirror and saw a half-wit staring back at me.

The only pending recordings I have on my BDA tuners are all, urrrm, scheduled for one tuner. :o :o

Both queries are doing exactly what they're supposed to.

Don't go away folks - next week I'm going to invent a glass drum.

Cheers,
Brian