Timeline for Use an Alias in Where Clause Subquery
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 16, 2013 at 11:55 | comment | added | haki | you can reference any column from the outer query at any level of sub query. this should not be a problem. do you get an syntax error when you try to execute the query ? | |
| May 16, 2013 at 11:53 | comment | added | ypercubeᵀᴹ | I'm not sure because of the double nesting. Can you check? | |
| May 16, 2013 at 11:52 | comment | added | haki |
i cant check the syntax but all i did was to change the alias KODE in the inner query to ANGGARAN.SIMPEG_PEGAWAI.ID_PEGAWAI. is it not working ?
|
|
| May 16, 2013 at 11:46 | comment | added | ypercubeᵀᴹ | The explanation of why the error occurs is correct. I'm not sure if your proposal is valid syntax though. | |
| May 16, 2013 at 10:52 | history | answered | haki | CC BY-SA 3.0 |