Hi, how do I get the SQL generated by Report Builder to generate Left Outer Joins? I've tried to add it from the table interface and i've tried to add it as embedded code, but it still generates the join as an Inner Join.Any ideas?
If you are using DADE, you can define a left outer join using the join dialog. For instance, if you start a new query designer and add two tables in the Tables tab, the join dialog will pop up. Then in the top left corner you can select which type of join you would like to use. The join dialog will also pop up when adding multiple tables in the Query Wizard.
Which version of ReportBuilder/Delphi are you using? Which database and connectivity are you using? If you open the join dialog and select Left Outer Join for two tables, then take a look at the SQL tab, it displays an Inner Join. In my testing, this does not occur and a Left Outer Join is properly displayed
Comments
If you are using DADE, you can define a left outer join using the join
dialog. For instance, if you start a new query designer and add two tables
in the Tables tab, the join dialog will pop up. Then in the top left corner
you can select which type of join you would like to use. The join dialog
will also pop up when adding multiple tables in the Query Wizard.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
other options?
Which version of ReportBuilder/Delphi are you using? Which database and
connectivity are you using? If you open the join dialog and select Left
Outer Join for two tables, then take a look at the SQL tab, it displays an
Inner Join. In my testing, this does not occur and a Left Outer Join is
properly displayed
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com