join query

[bubu2006]

I can see Crystal Report 10 has an outer join link option but I can not use that because it is disabled. I have two tables and I want to use outer join between two columns. Now I don't want to write command\view\stored proc. Is there any way I can enable outer join link option? I am using Oracle9i.

Thanks in advance,
bb

 

[synapsevampire]

Use the Add Command and paste in the SQL you need.

A shame you didn't state specifically what you want, a full outer, a left outer, a right outer...

-k

 

[bubu2006]

Full outer join. All other outer join condition is enebled only full outer join is disabled. I want to know whether I can enable outer join option or not. I know I can use command or view or stored proc.

 

[synapsevampire]

No.

Reference:

http://technicalsupport.businessobj...8&sliceId=&dialogID=360384&stateId=1 0 356275

-k