first. it should be a LEFT join, not a right....
secondly, where did "PhysicalAddress" come from? You didn't alias any of the tables as PhysicalAddress... it should be just tblTemp, both in the join and in the select...
-tg
|
Results 1 to 13 of 13
Threaded View
|
Click Here to Expand Forum to Full Width |
Reply With Quote