SELECT a.name, b.designation, a.salary, a.address FROM tblEmployees a INNER JOIN tblDesig b ON a.designation = b.id WHERE a.salary > 500
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)