I am wanting to build a report based on parent table and all related records
in 4 child tables. Some child tables might not have related records
so I would just want the emtpy or null value for the field I am trying to get from it.
Can 1 sql statement do this or will i have to build one cursor with key field and loop through each child table and populated report table?
I am trying inner/outer joins but if all criteria does not match, nothing
is pulled into query?

Any help would be greatly appreciated.. (also some resources on bulding SQL select statements!)

Thanks,
Ronnie