Links between tables in Crystal report has driection. What is it meaning

[zdehkordi]

Hi Friends.
I found that links between tables in crystal report has direction.
If I had three tables t1 t2 t3 which there are links
from t1 to t3
and from t2 t0 t3
there is an exception in showing report.

[boumerlin]

The links equal the following in SQL Syntax:

inner join
left join
right join

T1 inner join T3 means that you want only the records that match your join condition between T1 and T3.

T1 left join T3 means you want all the T1 records and if there are matching records in T3 you want those too.

T1 right join T3 means you want only the records from T1 that match your join condition to T3 and all the T3 records regardless of whether they match T1 records.

Linda