Full outer join not avaliable in database expert

[njahnavi]

Hi I am using crysal reports version XI release 2.

I thought this is simple however i am unable to get the results...

I have two tables
MasterTrailerInfo
InvTrailerInfo

Fields fro each table is as below
MasterTrailerInfo.TrailerName
MasterTrailerInfo.TrailerCount

INvTrailerInfo.TrailerEasilName
INvTrailerInfo.TrailerEasilCount

Sample Date

MasterTrailerINfo

TrailerName TrailerCount
A 23
B 32

INvTrailerInfo

TrailerEasilName TrailerEasilCount
A 11
E1 22

I want to link these two tables so that i get the following result..

A 11
E1 22
B 0

I thought i can acheive this by full outer join however that is grayed out in my crystal reports..

Please help.

 

[lbass]

I think you could use a command as your datasource and use a union statement like the following:

Select MasterTrailerInfo.TrailerName,
0 as TrailerEasilCount
From MasterTrailerInfo
Union
Select INvTrailerInfo.TrailerEasilName,
INvTrailerInfo.TrailerEasilCount
From INvTrailerInfo

The syntax for naming the field and the punctuation would be specific to your datasource.

-LB

 

[Turkbear]

Hi,
What database and what connection method?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[njahnavi]

Data base is sql server
Data base connection is Ado.net and then project datasource which is truckdatasource...

LB I can't use the command as a datasource...
as i am using this in a vb.net program and there is no option for a command query if i am not wrong...