Advertisement
Stybyk

zamestnanec a osoba ze stejne zeme

Nov 7th, 2014
482
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.22 KB | None | 0 0
  1. SELECT DISTINCT os.uID ,os.jmeno ,os.zeme ,po.zeme FROM osoba os
  2. INNER JOIN objednavka obj ON obj.uID = os.uID
  3. INNER JOIN zamestnanec z ON z.zaID = obj.zaID
  4. INNER JOIN pobocka po ON  po.pID = z.pID
  5. WHERE
  6. po.zeme = os.zeme
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement