2 Replies Latest reply: May 20, 2010 4:59 AM by marianasoares RSS

    Substitute a null field with another field from a different table



      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!