How to link based on one field OR the other available?

[CherrySoda]

Version 10.

I would like to setup a report that links two fields each from the same table in each database (interbase and excel). I want the second ID field linked in the event that there is missing or incorrect data from the first id field, and the ID numbers don't match.

For example:

InterbaseTable1.ID1 ----> Excel.ID1
*if not matching for the above, then use this:
InterbaseTable1.ID2 ----> Excel.ID2

What is the best way to approach this issue?

 

[IanWaterman]

Do it in the slect statement

(If InterbaseTable1.ID1 <> Excel.ID1
then InterbaseTable1.ID2 =Excel.ID2
else InterbaseTable1.ID1 = Excel.ID1)

Wrap in brackets as above so that you can add other clauses to select if required.

Ian