Need to show data with no match as well.

[dibar]

Hi, I am very very new to crystal reports.
I am using Crystal reports 2008


I am pulling information from two different data sources. I have an sql database called AXIOS_ASSYST_TRAIN and an excel spreadsheet called smsdata.

In Crystal reports I have created a connection to both sources and linked the two data sources with the field user_sc.

For each match there is for user_sc I display From the Axios database "user_sc", "branch" and "sector". From the smsdata excel spreadsheet I display "workstation_name", "Make" and "Model"

I have been able to get everything that has a match. But I also want to display all records from both databases that do not have a match between the user_sc field.

If there is no match between user_sc I want to display:

From the Axios Database
User_sc
Branch
Sector

From the excel spreadsheet
User_sc
workstation_name
make
model

I hope I was able to explain it clear enough

Any help you can provide is greatly appreciated.

Thanks
Di

 

[dibar]

I GOT IT!

LEFT OUTTER JOIN

Thanks

 

[dibar]

Sorry, but I don't think I ever replyed back to say thank you.

It was exactly what I need.

Thank you so much.