Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

  • RE: SQL & the JOIN Operator

    Jeff Moden (10/7/2009)

    Heh... of course, I will admit that, no matter which method someone uses to identify the column/table relationships, just about anything would be better than a format like...

    October 7, 2009 at 2:25 pm

    #1063073

  • RE: SQL & the JOIN Operator

    The bigger concern that I have is when people *do not* use any alias, even for a simple query. Then the next person comes along, adds a join without adding...

    October 7, 2009 at 1:07 pm

    #1063027

  • RE: SQL & the JOIN Operator

    Charles Kincaid (10/7/2009)

    '[' + syscolumns.name + ']' AS 'Column Name',

    Please...please please use QUOTENAME for things like this 🙂

    October 7, 2009 at 11:00 am

    #1062948

  • RE: SQL & the JOIN Operator

    Andy DBA (10/7/2009)

    Finally, somebody please correct me if I'm wrong, but I'm pretty sure you have to use aliases when writing queries with correlated subqueries.

    You don't HAVE to, but it...

    October 7, 2009 at 9:18 am

    #1062861

  • RE: SQL & the JOIN Operator

    I created this article/test page a number of years ago that describes Inner, Left, Right, Full, Cross, Triple, Self, Union and Union All queries. Joins[/url]

    October 7, 2009 at 8:48 am

    #1062829

Viewing 5 posts - 1 through 5 (of 5 total)