>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
If you have not read it already, look at 'What is an Outer Join?' in the FAQ section.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope