04/06/2014

Ambiguous column name error in SQL, how do I fix it

Ambiguous column error generally occurred while joining two or more table and where more than one table has same column name so to avoid such error just refer the table name and column name all together so instead of writing trg_PIS_No I have replaced it with tblemployee.trg_PIS_No and the error was fixed and my query is working fine.