Taking Rachael's idea a step further, try making a view that renames the columns that have a # in their names, and then do the INNER JOIN. If that works, then the problem area will have been identified, and you can figure out where to go from there.

Albert

John Croson wrote:
Rachael,

I'm using 6.5, but agree completely with your comment about the pound
symbol. I've inherited a bit of a mess, and have been cleaning it up far
too long...


Reply via email to