query 2 tables

[CanMan2004]

Hi all

I have a query which im trying to get to search two tables rather than one, the code ive used is

sql = "SELECT * FROM friends,customers ORDER BY RAND() LIMIT 34";

but for somereason it is only searching the "customers" table and is ignoring the "friends" table, what am I doing wrong?

Thanks in advance

Dave

[samshel]

This query will join the tables, not search the results in both and list them one below another....If you need records from both the tables, use 2 seperate queries...