>>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?
>>

>If you have not read it already, look at 'What is an Outer Join?' in the FAQ section.

I looked in the SQL FAQ and the General FP FAQ but could not find it. Do you know where it is?

Thanks

Brenda