Advertisement
Guest User

Untitled

a guest
May 29th, 2016
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. SELECT
  2. t1.*, t2.c2name, t2.m2id
  3. FROM
  4. (SELECT m1.* FROM Member m1, User u1 where m1.User_id = u1.id AND m1.Club_id is null) t1
  5. LEFT JOIN
  6. (SELECT m2.id AS m2id, u2.id AS u2id, c2.name AS c2name FROM Member m2, User u2, Club c2 where m2.User_id = u2.id AND m2.Club_id = c2.id) t2
  7. ON t1.User_id = t2.u2id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement