--- In firebird-support@yahoogroups.com, "William L. Thomson Jr."
wrote:

> I need one query that returns all records in table B.

This is so simple that it either has to come from a complete newbie
(which I know you're not) or I must have misunderstood the question.
Anyway, here goes so that you can 'clarify my misunderstanding':

select <something> from B

> Then another query that returns only the records in C, that are not
> in B.

select <something> from C
where not exists (select * from B
where B.<field> = C.<field>)

HTH,
Set