it used to work...

[Ivan Smahin]

Hello Danny,

Monday, May 25, 2009, 2:56:46 PM, you wrote:

> Hey Guys,

> I get errors on queries like these:

> Select RecID,... FROM tbl_1 JOIN tbl_2

> Which is good, because it says now, RecID is not unique, and that is  
> correct...
> But, this used to work!! :-) We have a lot of queries like that (which
> is not so good of course),
> and my question now is : has there been changes in that area?

No it is so for a long time.
No  changes  here.  You  should  use  different aliases for same-named
columns to identify them.

> Or why is that happening now, and not in the passed?

Probably  you wrote something like "select ** ..." before or select no
same-named columns...


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com