Re: Inconsequences in SELECT/ORDER BY

>>Now I tried: SELECT col_a, col_b, col_a FROM tab ORDER BY col_a; >> >>I received the "ambiguous column" - error. I think that in this context >>this error should NOT be reported. >> >>What is the opinion of the net? Is the error reporting correct or not? >I have no problem with it reporting an error. It's just asking which column(s) >you want your data sorted by... You know what I hate? (try to imagine me as Andy Rooney saying this) ... - When you say: select col1, col2, col3 from prod_mast, prod_type where prod_mast.prod_12 = prod_type.prod_12 and prod_12 = 492 and the thing complains about prod_12 being "ambiguous". I mean for heaven's sake man, figure it out. Propogate constraints or something. Decades of work on artificial intelligence and you get thrown by something like this? I think I had better go and have a little rest now.