Selecting records from three tables...

[Anon]

I need some help extracting information from a table but I only wish to take info from it if certain conditions are met in another table, if that makes sense.

From table1 I only wish to extract the record IF firstly there is a record in table2 with the same id as the id in table1. Secondly I only wish to extract the records from table1 only if there isnt a record in table3 with a the same id as in table1 AND the ribbon_id is the same as the ribbon_id in table one.

To summarise only records from table1 can be selected if there is a record in table1 with the same id AND there isnt a record in table3 with the same id and ribbon_id as in table1.

Any help is most appreciated. Thanks

Rob

[Anon]

For the first part, it's pretty straightforward:

select table1.column1, ... from table1, table2 where table1.id = table2id;

For the full query, I think you can do something like this:

select table1.column1, ...
from table1, table2
where table1.id = table2id
and table1.id not in
(select table1.id from table1, table3
where table1.id = table3.id
and table1.ribbon_id = table3.ribbon_id);

If your dbms doesn't support NOT IN, you probably have to do two
queries.