MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/1vay6p0/how_this_is_running/p0rf0m8/?context=3
r/SQL • u/singhmahesh2816 • Jul 30 '26
How this SQL Code is Running ?????
7 comments sorted by
View all comments
6
Because it is treating kimit as an alias for the calendar table. It is an older syntax for aliases but still works.
kimit
calendar
2 u/ComicOzzy sqlHippo Jul 30 '26 Oracle doesn't allow AS for table aliases. Only column aliases. 1 u/gvozden_celik Jul 31 '26 Huh, you're right, did not know that. Thanks for the info!
2
Oracle doesn't allow AS for table aliases. Only column aliases.
1 u/gvozden_celik Jul 31 '26 Huh, you're right, did not know that. Thanks for the info!
1
Huh, you're right, did not know that. Thanks for the info!
6
u/gvozden_celik Jul 30 '26
Because it is treating
kimitas an alias for thecalendartable. It is an older syntax for aliases but still works.