I have 2 files ( Current & History ) that I would like to join in my sql.
I 'm not sure which file the records are in. I would like to check the current file first if the records are not present then i would like to check the history. I've no idea how to place logic around the joins. Something like this.....
Select a.field1, b.shpdt from myfile a
join current b on a.field1 = b.field1
join history b on a.field1 = b.field1
Is something like this even possible?