|
|
Posted by Ryan Lange on 11/04/29 11:41
Ja NE wrote:
> it is working... maybe is there some shorter and more eficient way, but
> I just don't understood arrays yet/still...
What database are you using? The following works in PostgreSQL 8.1:
'SELECT * FROM photo
WHERE album_id NOT IN (SELECT album_id FROM album)'
This will return all of the records in table "photo" that belong to
an album that doesn't have a corresponding ID in table "album".
- Ryan
Navigation:
[Reply to this message]
|