Solved

Equivalent LEFT JOIN SQL?

Posted on 2011-02-21
3
771 Views
Last Modified: 2012-05-11
A while back I asked a question which helped me to build the following (first) SQL statement. Out of interest. Could somebody tell me if both of the following statements are identical. Is the alias just for convenience, or could it alter the output in any way?

SELECT t1.* FROM user_group_link AS t2 LEFT JOIN user AS t1 ON t2.user_id = t1.id WHERE t2.group_id=[b]INPUT[/b]

Open in new window


SELECT user.* FROM user_group_link LEFT JOIN user ON user_group_link.user_id = user.id WHERE user_group_link.group_id=[b]INPUT[/b]

Open in new window

0
Comment
Question by:numberkruncher
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
markterry earned 500 total points
ID: 34944612
Yes, they are the same. Aliases are simply to shorten your object names in a query. This way you can give your tables descriptive names, and not have to be constantly inconvienced by the name while typing.
0
 
LVL 6

Expert Comment

by:markterry
ID: 34944635
in fact, if the colum names are unique to all tables, you do not even need the tablename.columnname, you can just put colum name. But this is not good practice.
0
 
LVL 13

Author Comment

by:numberkruncher
ID: 34944704
Thanks, I wasn't sure what the AS was giving an alias to the table name or whether it was giving a name to a set of results which had to be re-addressed.
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question