it used to work...

[Ivan Smahin]

Hello Ivan,

Monday, May 25, 2009, 3:31:15 PM, you wrote:

> 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.

I meant full qualified names - not aliases :)

>> 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