Hi Adrian.Opera,
I observed that , you haven't used the Alias names for any of the tables you used in the query.
But i think, it is better to use the Alias names, as it reduces the code length.
Please let me know , if there is any advantage of not using the alias names for the tables.
Thank you,
Raj..
How to simulate Subqueries in the ON Clause in Vertica
Moderator: NorbertKrupa
-
- Intermediate
- Posts: 87
- Joined: Wed Apr 25, 2012 8:10 am
Re: How to simulate Subqueries in the ON Clause in Vertica
Last edited by rajasekhart on Tue Jun 11, 2013 9:59 am, edited 1 time in total.
Rajasekhar.T|HP ATP Vertica Big Data Solutions V1
-
- Intermediate
- Posts: 163
- Joined: Tue Jun 19, 2012 2:44 pm
- Location: Rio de Janeiro
- Contact:
Re: How to simulate Subqueries in the ON Clause in Vertica
Rajbldsda you can do better..... my name is as it's written and not how you pronounce it!rajasekhart wrote: Adrean Opera,
Raj..
trying so hard !!!