select data from two tables.
 

Hi, I am trying to select site fields from two tables. The first table is called 'users' and has a field called 'location' and the other table is called 'addsites' and that also has a field called 'location'.

Could someone please show me how I would select the data from both 'location' fields using one php SELECT routine.

I hope someone can help.

Thanks