[RESOLVED] DB Returning Too Many Results

[timska77]

Well, I'm back. For some reason the following database call is giving me problems:

SELECT a.lname, a.fname, a.town,, a.cust_id, b.email FROM table1 AS a, table2 AS b WHERE a.lname LIKE '$var' OR a.fname LIKE '$var' ORDER BY a.lname

There are three users and this call returns the same user three times but with the three different cust_ids. Like this:

Doe John San Diego 534 [e-mail]
Doe John New York 236 [e-mail]
Doe John Scottsdale 871 [e-mail]

Both tables have a cust_id column. If I limit the call like this to one table it works:

SELECT lname, fname, town, cust_id, FROM table1 WHERE lname LIKE '$var' OR fname LIKE '$var' ORDER BY lname

Any ideas what I'm messing up? Thanks in advance.

[timska77]

OK, I got it. I goofed with the thing for an hour before making this post and then just a few minutes later realized that i didn't have a conditional in the where clause to link the two tables.