select * from UserMaster us left join pageRightMaster pg on u.id = pg.fk_userId
SELECT * FROM pages_mst u LEFT JOIN user_page_rights_mst up ON u.id = up.fk_page_id And up.fk_userId = 1 LEFT JOIN users ON up.fk_userId = users.id
WHERE
users.id
NULL
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)