2006/1/11, Zabach, Elke <[EMAIL PROTECTED]>: > Therefore the idea of Robert is not too bad: > > SELECT ID_F, tsub.VAL_F > FROM MAIN_TBL, > (SELECT VAL_F FROM ... > WHERE tsub.VAL_F = 3) tsub > where tbl.idf = tsub.... > and .... > > It has only one mistake: the alias used for the result of the > from-select van NOT be used as tablename IN that select, only in the > upper one, where the alias is known. (The second difference was, I > assume, just a misspelling: tbl --> main_tbl)
Yes. And the other one was a copy and paste error. You're of course right on both. Thanks for catching that, Elke. > But why do it that way? Why don't use just a normal join? I'm wondering, too. Kind regards robert -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
