Im trying to check for a column[EMPID] in a table [EMPLOYEE] if exist i have to consider the values from that column, if not it have to refer to another TAble[Details] and column[EMPID]. Please somebody can answer this. Im trying to check for a column[EMPID] in a tab