[CR 8.5] external joints ????

[joe69008]

hi guys,

I want to know please if is possble to use left join or right join in CR 8.5.

for example,


I have one table apartment(id_apartment,id_rent,adresse...) et one table rent(id_rent, amount).
But all apartment don't have a rent (The owners do not pay rent). So when i do a report where i want all apartments with there rent, only those which have rent Appears. with a sql request it's easy to appears all apartments with and without rent (with external joint) but with CR, i don't see how i can manage to do that. i see in (+) in request editor but when i modify it, my request doesn't work anymore.

Somebody can help me and say me how to do.

Thanks a lot

Excuse me for my mistake of spelling and expression but I don't speak english very well.

 

[lbass]

Go to database->visual linking expert and link the two tables there. Then click on the join until it turns white->link options->left join. This will automatically generate the correct SQL query.

-LB

 

[joe69008]

thanks you very much