Information générale
Catégorie:
Gestionnaire de rapports & Rapports
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement