Select 2 Tables At Once

[johnnyd1963]

My question is

 

How to select form 2 tables where column1 = x order by column2 desc

 

in PHP MYSQL

 

thanks in advice John

[silkfire]

You'll have to use a JOIN of some sort on a column with common values.

[johnnyd1963]

Tanks for your advice

 

i got

 

$query3 ="SELECT * FROM narr_turnier_".$onlyconsonants." UNION ALL SELECT * FROM narr_turnier_".$onlyconsonants."_ster WHERE id_turnier_jaar=".$idjaarturnier." order by rang";