[thelist] sql statement

[Ed McCarroll]

> Well in teh case of the address it should return a match or
> nothing

Then you want an INNER JOIN.

INNER JOINs are what you get if you imply the join in the WHERE
clause.  They are also implied if you just use JOIN without INNER,
OUTER, LEFT, etc.

And if you haven't already, get a tutorial-style book on SQL.  I've
had good luck with books with titles like "Teach Yourself ... in 21
Days", "... Crash Course", and (last & least) "... For Dummies".

-- 
Ed McCarroll                                  (310) 838-4330
Ed at ComSimplicity.com            http://www.ComSimplicity.com