Am I getting all these problems because I'm running Windows XP? Or is it because my DB is on Windows Server 2003? What test environment do you have? It makes no sense that you guys can never reproduce my errors..
You guys keep asking for test data… I'm telling you this error occurs on ANY database I have (Yes I have more than one) Anyway, I spent the time to make up some dummy tables for you, since I cannot provide my data from work anyway. The error occurs with these tables just the same as any other tables in any other DB that I need to manage.
PS It would make sense if you guys allowed files with a .sql extension to be uploaded to the message board, no?
Code:
select t1.id, t1.Desc1, t1.Desc2, t2.Desc3, t2.Desc4
from table1 t1, table2 t2
where t1.id = t2.Table1ID