Where to find help on CR "JOINS," differences, etc. 1

[BigDogAZ]

I write reports with CR10 often using 10 tables, lots of links, and occasional "joins" in order to get what I want out of our ERP system. Where can I find more about joins, when/how to use them, why they work, the difference between a left and right outer join, etc. I've looked here, under FAQs and posts, but can't find anything that explains them.

I want to understand the following CR joins:
- Inner Join
- Left Outer Join
- Right Outer Join
- Full Outer Join

 

[synapsevampire]

You'd probably be better off to focus your studies to specifically using the SQL for your database.

At any rate, here's some:

http://www.profsr.com/sql/sqlintro.htm

http://www.databasejournal.com/sqletc/article.php/1402351

-k