Smashing...Perfect.

Thanks:cool:

Thanks RBarryYoung:

This has a problem " Incorrect syntax near the keyword 'ON'.".

First option gave "Invalid object name 'Source'"

The info required is found using a key and is located on table-a or table-b. The result gave the info on table-a (if available), else found the info on...

Thanks Seth & Jerry,

The second option works better for me.

Balv