|
well,
the
error
you
|
|
|
|
|
well, the error you getERROR at line 15:ORA-25154: column part of USING cluase cannot have qualifieris exactly that. You can not put anywhere in your statement things like t.id =3 (in the SELECT or the WHERE cluase) as the error message suggests. Instead you would have to put just id = 3 , without the table alias (qualifier). This also applies to doing something like SELECT S.* from and then ANSI JOIN with the USING keyword. It would result in the same error being raised. If you alter your example to reflect this, you will then see that the USING part does not extend outside of the parentheses and the WHERE keyword must follow before you put other predicates.
|
|
|
|
|
|
|
|
|
(VISITOR) AUTHOR'S NAME Julia
MESSAGE TIMESTAMP 16 december 2014, 13:28:11
AUTHOR'S IP LOGGED 62.210.78.179
|
|
|
|