full outer join

[unknownly]

Hi,

I haven't done any report like this before and need help. Using ver.CR10.
I need to do a report to bring in the data sets from the tables of 2 different datasources and do a full outerjoin on the tables from both the datasources.

How can I do this or any alternatives to get this results.

TIA,
Sweetie

 

[synapsevampire]

Crystal doesn't support Full Outer Joins for purely BS reasons, I won't even bother to quote their nonsensical reasoning.

Please remember to post your database version and the type of connectivity, you're asking about a database join here, right?

Anyway, under the connectivity you'll see Add Command, you can paste SQL in there to do a Full Outer, or you might just use a Union All query to do the equivalent.

Do you even know if your database supports a Full Outer?

Anyway, a Union All should work in almost all databases.

-k

 

[unknownly]

I know the few feature for full outer join in Oracle 9i. Iam using Oracle 9i version.

But wasn't sure if that would work if I use as a cut paste in as a command.

Thanks,
Sweetie

 

[synapsevampire]

Commands are processed on the database, so I'm not sure why you thought Oracle might not allow it if you knew that Oracle supported it.

Also please remember to post basic environment information when you post, rather than having to be asked every time.

btw, I just responded to yuour other post, requesting technical information prior to reading this.

-k

 

[IdoMillet]

Actually, full outer join scenarios are typically best approached using UNION rather than UNION ALL (unless you are very careful about your statements).

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[unknownly]

Need help to Identified which columns are missing from tab1 and tab2

Using CR 10 and Oracle 9i

I am bring data for 2 tables using the follwing sql

ex: select tab1.column1, tab1.column2,tab2.column1,tab2.column2
from tab1 full outer join tab2
on tab1.column1 = tab2.column1

I need to display in the report like as status

111 aaa missing from tab1
101 aba missing from tab1

hope you understand what I asking...


TIA,
Sweetie