joining 3 tables

[ginaburg]

Is it possible to join 3 tables.
I created a SQL view that joins 2 tables using full join but is there a way to join a third one to that view?

Thanks
Gina

 

[cLFlaVA]

Yes, there is a way. Without sample code, I can only give you a vague example:

SELECT *
  FROM table1 t1 JOIN table2 t2
    ON t1.col1 = t2.col1 JOIN table3 t3
    ON t1.col2 = t3.col2

*cLFlaVA
----------------------------
Lois: "Peter, you're drunk!"
Peter: "I'm not drunk, I'm just exhausted from stayin' up all night drinking!

 

[ginaburg]

Thank you. That will help.

Gina