Hi list, I ran into interesting issue. I have a query:
SELECT ID_F, (SELECT VAL_F FROM ...) AS VAL_F FROM MAIN_TBL WHERE VAL_F = 3 This doesn't work: Unknown column name:VAL_F Actually I cannot refere any field by alias, not only subselect, but for other types of fields there are other ways to refere them. Is there any way to refere this VAL_F field in the condition? Thanks in advance. Alexei Novakov -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
