Advertisement
nocturnalmk

[BP] detali za lokacija

Apr 17th, 2013
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.23 KB | None | 0 0
  1. SELECT l_id, l_ime, l_slika, l_opis, l_adresa, (SELECT g_ime FROM gradovi WHERE g_id = lokacii.g_id) AS grad, (SELECT (SUM(o_ocenka)/COUNT(o_id)) AS ocenka FROM ocenki WHERE l_id = lokacii.l_id) AS ocenka FROM lokacii WHERE l_id = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement