Hi, Bill! Sylvain suggested the same thing - but what syntax would I use to do a LEFT OUTER JOIN to Reps.Rep_Code AND LinkManu.Lib_Code AND Linksect.Lib_code (all three in one query)???
TIA
>Hi Michael,
>
>If you are using VFP 5 or 6, why not use LEFT OUTER JOIN to each of the child tables?
>
>>My app has a parent table (A) with several child tables (B, C, D). Some parent records do not have associated records in on or more of it's child tables.
>>
>>I use a SQL statement to a cursor for searching purposes. I know I can probably write a seperate SQL statement to get parents without children in table B but WITH children in C and D, and then another without children in C but with children in B and D... etc - and do a UNION between them all - but that's hard to write and hard to maintain!
>>
>>Has anyone come up with a better way?
>>
>HTH,
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site