Best way to report parent records with no children.

[Peager]

What's the best way to select records from a parent file that have no corresponding children in another file? I'm trying something like this but it's VERY slow.

Select Account, Company
From Customer
Where (Company + Convert(Seq_No,SQL_Char))
Not in (Select Distinct Company +
Convert (Seq_No,SQL_Char)
From Labels)

Customer is the parent, Labels is the child and they are related on Customer + Seq_No.

Thanking all in advance.

Paul

 

[synapsevampire]

I think you mean that they are NOT related.

Just join the 2 tables in Crystal using a left outer and then add to the report->edit selection formula->Record

isnull(child.Customer)
or
isnull(child.Seq_No)

This assumes that neither is null in the parent table.

Should be quick.

-k

 

[Peager]

Sometimes I try really hard to make something difficult that is Soooooooo easy. Thanks for being gentle with my stupidity.

paul