Menu
Community /Pin to ProfileBookmark
@NogDogSep 15.2012 — #If the two tables are truly separate (as opposed to joined on a common field), then you may need to do a union
Note that you must select the same number/type of columns from each table.
[RESOLVED] Select from 2 tables
I have 2 tables: lss1 & lss2 and the content needs to be selected from either table depending on the criteria.
[code=php]$sql=”SELECT * FROM lss1, lss2 WHERE id=$variable”;
I am getting the following error: “Couldn’t execute query: Column ‘id’ in where clause is ambiguous”
How do I not make the “id” ambiguous when it could go to either table?
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogSep 15.2012 — #If the two tables are truly separate (as opposed to joined on a common field), then you may need to do a union[code=php]
select col1, col2, col3 from table1 where something='something'
union
select col2, col2, col3 from table2 where something='something'
[/code]Note that you must select the same number/type of columns from each table.