using CASE in MS Access select query

Hi,



I'm using 2 tables A & B. The structure is

a: emp_id, name, value, check

b: emp_id, name, value

check field in table A is yes/no field.



Question: An sql query which can,



If check= 'yes' pull record from table B else from table A, for emp_id = User entered Id





I'm using Access 2k. The result should be compatible.

arvind,





Why have you got the same three fields in two tables? (emp_id, name, value,)



Give us an idea what you are trying to do.



Post a copy of your database







Regards,