Hi,Is it possible to join two tables based on the specified condition. For example, i have two tables t1,t2 and t3. The table t1 and t2 has field called name and the table t3 has field name class. I want to select the names from t1 or t2 based on the condition of class(t3).If class=4 then select name from t1, if class=10 then select name from t2. Please say me the query.Regards,Suganya