I often hear about an inner, outer, left and right joins. What is the difference in the SQL and in the result sets.

I use "FROM table1, table2 WHERE custno = custno" often and realize it only picks rows from the two tables that match. What is this kind of join called?

Thanks

Brenda