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,