I need help with the following logic:
I have two tables
When inv_corp.btlr_dlvr_pnt_no = hst_ref.old_dlvr_pnt_no Then select hst_ref.new_dlvr_pnt_no Else inv_corp.btlr_dlvr_pnt_no
I feel i could easily do this in the SELECT statement had there been a static field I could join to of the table. But being that the joining of these two tables is dependent on a criteria first it make this a little trickier for me.
Any help would be much appreciated