JOINs verses ='s ?

Hi,

I am being pushed by the management to learn SQL on my own - and now, I am (maybe) stumped with left / right / outer joins...

Let's say that I have 2 tables with 2 cols : Table #1 - id (pri. key), fn
Table #2 - id (pri.key), ln

Now, my own SQL instruction would be:
select table1.fn, table2.ln FROM table1, table2 WHERE table1.id = table2.id AND table1.id = 1;

Would I be correct in extrapolating this to:

select table1.fn, table2.ln FROM table1, table2 WHERE table1.id LEFT JOIN table2.id AND table1.id = 1; ?

If not, could anyone give me a quick overview of left / right / outer joins in an SQL instruction?

Cordially,

Daniel Page Received on Mon Apr 09 2001 - 10:28:52 CEST