2 selects in one page

[Anon]

can I select from 2 tables with one sql command (using mysql as the database) If not can I build a table using 2 different select statements?

[Anon]

Please say more: are the two tables related in any way? etc...

[Anon]

i need to pull data from 2 different tables together into one (html) table.

[Anon]

Yes - that's the basis of relational databases.

You can say something like this:

SELECT tbl1.fld1, tbl1.fld2, tbl2.fld2
FROM tbl1, tbl2
WHERE ...etc.

Note that you don't really need to specify the table names when refering to the fields (unless there are similarly-named fields in more than one table), but it's probably a good habit to get into.

-Keegan

[Anon]

Or...

select t1.something, t2.something from table1 t1, table 2;

I think that's the right syntax 🙂

[Anon]

Supposing you've got a table with users or members, and another one with address details in. You want to pull up all the user details plus the address for a given user..

SELECT u.firstname, u.lastname, a.address1, a.address2, a.postcode
FROM users u, addresses a
WHERE u.id = 12345 AND u.addressid = a.id

This assumes that your users are identified by a numeric ID, as are addresses, and the user record has a field that references the ID of the address that's applicable to that user.

Hope this helps - feel free to drop me a line if not.

Cheers
Paul