Joins 1

[wakthar]

In my report I want to join two tables Contracts and Turnover. When I use Database Expert and join the fields, the generated sql produces an INNER JOIN instead of the LEFT JOIN I wanted.

Two tables are joined on region, contract, period and year.
The generated SQL is

SELECT Crt.year, Crt.period, Crt.region, Crt.CrtNo, Cqt.Turnover
FROM Contracts Crt, Turnover Cqt
INNER JOIN Cqt ON
(((Crt.region=Cqt.region)
AND
(Crt.CrtNo=Cqt.CrtNo))
AND
(Crt.year=Cqt.year))
AND
(Crt.period=Cqt.period)
WHERE
Crt.year=2006 AND Crt.period=3 AND Crt.region LIKE '%'
ORDER BY Crt.region, Crt.CrtNo


Instead of the INNER JOIN I would like to replace it with a LEFT JOIN.

Can this be done in the Database Expert??

 

[IdoMillet]

Click on the "Links" tab in Database Expert.
Select the links and change them.

- Ido

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

http://www.MilletSoftware.com

 

[wakthar]

Thanks for that...

How do you exactly 'Select the links and change them'?

As I can see, you can only link them one way and thats by dragging and dropping.

How do you change the sql generated from an INNER JOIN to LEFT JOIN?

 

[IdoMillet]

Click on the join line to select it...

- Ido

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

http://www.MilletSoftware.com

 

[wakthar]

wahey!!!!

Cheers ;-)