select pmtblempreg.Id,pmtblempreg.Name,pmtblempreg.UserName,pmtbldesignation.Designation, pmtblempreg.skypeid,pmtblempreg.EmailId from pmtbldesignation right join pmtblempreg on pmtbldesignation.Id=pmtblempreg.DesignationId
SELECT PMTBLEMPREG.ID, PMTBLEMPREG.NAME, PMTBLEMPREG.USERNAME, PMTBLDESIGNATION.DESIGNATION, PMTBLEMPREG.SKYPEID, PMTBLEMPREG.EMAILID FROM { oj PMTBLDESIGNATION RIGHT OUTER JOIN PMTBLEMPREG ON PMTBLDESIGNATION.ID = PMTBLEMPREG.DESIGNATIONID }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)