Tracy,
Did you post this on Friday? <g>
What about
select * from Parent Left JOIN FirstChild on Parent.PK = FirstChild.fk ;
left join SecondChild on Parent.Pk = SecondChild.FK
?
>I have one parent table and two children. I want to create one table with the fields from all three (for a report). Is there an easy way to do this without hardcoding the fieldnames?
>
>For example,
>
>Parent table = table1
>1st child = table2
>2nd child = table3
>
>use table1 order tag site
>use table2 in 0 order tag site
>use table3 in 0 order tag site
>
>sele table1
>set relation to site into table2
>set relation to site into table3 additive
>set skip to table3
>
>Instead, I want one cursor with the fields for all three so I can use it in a report easier.
If it's not broken, fix it until it is.
My Blog