Index Page | Login Page | Registration Page
PREVIOUS MESSAGE(S)
'Sevilian Board index page
'*shudders*... I am NOT a fan of Office 2007...' posted by Little green man - 21/10/2008, 00:01:51
'But it all makes perfect sense...' posted by §evqui§ - 21/10/2008, 00:14:29

CURRENT MESSAGE

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




REPLIES TO THIS MESSAGE

- no replies yet -



REPLY FORM

name:
email:
title:
message:
Please type the text of the image below into the text box here to confirm that you are human, before posting a comment:

  sign post using your signature    |      no text
    
Index Page | Login Page | Registration Page
















message was viewed 610 time(s).