Sql Server Left Outer Joins

[deborahb]

MSSQL Server Report:

I created report with three tables left outer joined to one another.

The code that Crystal created for me joins them in the where clause ... table1.fld *= table2.fld, etc.

I get a GENERAL SQL ERROR when running it. If I change the code to table1 left outer join table2 on table1.fld = table2.fld it runs. Is there some option I should set or something so that I can use the code that Crystal created for me?

Thanks in advance.

Deborah

 

[Crystalguru]

Deborah,

Did you solve this problem yet? I have run into the same issue and cannot figure out why it won't let me left outer join two tables. I tried doing this on another database and it allows me to left outer join two tables.

crystalguru

 

[deborahb]

Seems so long ago.... The problem is that the default code writer that writes sql such as table1.fld *= table2.fld is outdated and only supports one level of outer join. But - one can write code such as

table1 left outer join table2 on table1.fld1 = table2.fld4
left outer join table3 on table2.fld2 = table2.fld1

etc.

This does work. In general I've bypassed all these problems by just using ado recordsets and writing the sql I want.

Hope that helps.

Deborah

 

[bjrollet]

Finally, someone else with this problem. It is very frustrating that this happens. I can't stand it. I get around it by writing the query with the correct syntax in Enterprise Mangler the put it in to CR. If you guys find a solution, don't hesitate to post it.