>>>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
Look for it under 'Coding, syntax & commands' section
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope