This content has been marked as final. Show 2 replies
I would like to know how can I substitute a field in a table with other field existent in other table if both tables are linked to each other.
For example, what I want to do is if (isnull(TableA.x), TableB.y, TableA.x).
If filed x from table A is null I want to substitute that field with field y from table B. Table A and B are linked through a common field.
Thanks in advance!