SELECT
EMPLOYEE.NAME AS 'NAME',
EMPLOYEE.ADDRESS AS 'ADDRESS',
PROJECT.PROJECT_NAME AS 'PROJECT_NAME',
EMPLOYEE.ADDRESS AS 'SDASDADASDAD',
PROJECT.PROJECT_NAME AS 'DSASADADADADSADDSADADAD',
EMPLOYEE.PHONE AS 'SADSDSADADA',
PROJECT.PROJECT_NAME AS 'ADADSADSAD',
EMPLOYEE.PROJECTID AS 'DADADSAD',
EMPLOYEE.PAN AS 'ADADSADDSADSADSADADSADA',
EMPLOYEE.ADDRESS AS 'ADDSADSADADSADADA',
PROJECT.PROJECT_NAME AS 'SADDSADDSADSADA',
PROJECT.PROJECT_NAME AS 'SADDDSADADA'
FROM
EMPLOYEE EMPLOYEE INNER JOIN PROJECT PROJECT ON EMPLOYEE.PROJECTID = PROJECT.IDPROJECT
WHERE
EMPLOYEE.PHONE = '9791048203' AND
EMPLOYEE.PAN = 'ABC100'
Sample Query to test:
SELECT EMPLOYEE.NAME AS 'NAME', EMPLOYEE.ADDRESS AS 'ADDRESS', PROJECT.PROJECT_NAME AS 'PROJECT_NAME', EMPLOYEE.ADDRESS AS 'SDASDADASDAD', PROJECT.PROJECT_NAME AS 'DSASADADADADSADDSADADAD', EMPLOYEE.PHONE AS 'SADSDSADADA', PROJECT.PROJECT_NAME AS 'ADADSADSAD', EMPLOYEE.PROJECTID AS 'DADADSAD', EMPLOYEE.PAN AS 'ADADSADDSADSADSADADSADA', EMPLOYEE.ADDRESS AS 'ADDSADSADADSADADA', PROJECT.PROJECT_NAME AS 'SADDSADDSADSADA', PROJECT.PROJECT_NAME AS 'SADDDSADADA' FROM EMPLOYEE EMPLOYEE INNER JOIN PROJECT PROJECT ON EMPLOYEE.PROJECTID = PROJECT.IDPROJECT
WHERE EMPLOYEE.PHONE = '9791048203' AND EMPLOYEE.PAN = 'ABC100'