Re: A very simple SQL question.

Constantino Cremidis wrote: > > Hello: > > Although I have been using SQL for some years I do not remember > getting this this SQL error. Can someone explain me why this is an > error. > > SELECT a.col1, a.col1, a.col3 FROM table1 a, table2 b > WHERE ^^^^^^ > a.col1 = b.col1 AND > table1.col4 = "SOME_VALUE" > ^^^^^^> > Fails with error 522 Table (table1) not selected in query. > For the purposes of the query, you're renaming table1 to 'a' and table2 to "b". The last line should read a.col4 = "SOME_VALUE" - JFV