How to simulate Subqueries in the ON Clause in Vertica

Moderator: NorbertKrupa

rajasekhart
Intermediate
Intermediate
Posts: 87
Joined: Wed Apr 25, 2012 8:10 am

Re: How to simulate Subqueries in the ON Clause in Vertica

Post by rajasekhart » Fri Jun 07, 2013 12:01 pm

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..
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

adrian.oprea
Intermediate
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

Post by adrian.oprea » Mon Jun 10, 2013 11:05 pm

rajasekhart wrote: Adrean Opera,
Raj..
Rajbldsda you can do better..... my name is as it's written and not how you pronounce it!
trying so hard !!!

Post Reply

Return to “Vertica SQL”