A very simple SQL question.
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.
Is this an ANSI or an Informix Restriction?
Tino.
PS. Sorry if this is too obvious but I am just curious.