Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- t1.*, t2.c2name, t2.m2id
- FROM
- (SELECT m1.* FROM Member m1, User u1 where m1.User_id = u1.id AND m1.Club_id is null) t1
- LEFT JOIN
- (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
- ON t1.User_id = t2.u2id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement