CONVERT FUNCTIONS WITH JOINS : SELECT D.DATEVAL,D.DAY,D.MONVAL,D.YEARVAL,E.HIREDATE FROM DATE1 D,EMP E WHERE TO_DATE('D.DATEVAL-D.MONVAL-D.YEARVAL','DD-MON-YYYY')=E.HIREDATE; 
IS THIS SUBQUERY IS CORRECT OR NOT? 




 My requirement is dispaly date1 table columns along with hiredate, the date1 columns are derived from hiredate by using TO_CHAR() fn. Note:there is no hiredate column in date1 table