order by citas tabula

[EdgarsK]

Sveiki, pieņemu ka ir jālieto kaut kāds joins, bet man ar joiniem ir problēmas, varbūt variet uzrakstīt.

 

tabula 1

c_id,c_title,c_user

tabula 2

c_id,c_clicks,c_visits

 

gribu lai "Select * from tabula1 order by (tabula2.c_clicks+tabula2.visits)"

[Aleksejs]

SELECT * FROM tabula1 LEFT JOIN tabula2 ON tabula_1.c_id = tabula2.c_id ORDER BY (tabula2.c_clicks + tabula2.c_visits); -- Nezinu, gan vai pēc lauks1+lauks2 var kārtot.