|Subject||Re: [IBDI] Digest Number 419|
>select a.compname from company a , employee bI don't get it. If you're doing an equijoin (a.compname = b.compname) than
>where a.compname = b.compname
>and b.empno = :empno
>order by compname
>The ambiguity here is that the statement does not identify which table's
>compname to order by and the results are somewhat unpredictable -
>contradictory, even, if you compare database versions.
does it really matter whether the DB engine will use a.compname or
b.compname for sorting the result set? I understand this could be the reason
for underperformance on the server side, but the RESULTS of the SQL query
should be the same and not "somewhat unpredictable". Am I missing something?
<br><br><br>Be healthy, stay wealthy...
Visit Belarusan Music Source - http://www.belmusic.net
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp