Results 1 to 4 of 4

Thread: [RESOLVED] Deprecated Join Syntax

  1. #1

    Thread Starter
    Super Moderator dday9's Avatar
    Join Date
    Mar 2011
    Location
    South Louisiana
    Posts
    9,738

    Resolved [RESOLVED] Deprecated Join Syntax

    I am in the process of converting a legacy VB6 (started as VB3) application to Angular (front-end) and C# (back-end).

    The code makes use of deprecated join syntax everywhere. The one that most commonly see is the left outer join tableA.column *= tableB.column

    However, I've come across one where the FROM clause is setup similar but the WHERE clause uses just an equal sign. E.g.:
    Code:
    SELECT
        ...
    FROM
        TableA, TableB
    WHERE
        ...
        AND TableA.Column = TableB.Column
    I just assumed that this meant that it was an inner join, but I wanted to verify that here first before I replace it.
    Last edited by dday9; Sep 24th, 2020 at 03:03 PM.

  2. #2
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,530

    Re: Depreciated Join Syntax

    You are correct, it is an Inner Join

  3. #3

    Thread Starter
    Super Moderator dday9's Avatar
    Join Date
    Mar 2011
    Location
    South Louisiana
    Posts
    9,738

    Re: Deprecated Join Syntax

    Sweet, thank you!

  4. #4
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,431

    Re: [RESOLVED] Deprecated Join Syntax

    I hate still running into that syntax, still see it once in a while, even worse is when you see the old Oracle syntax
    Code:
    .....
    FROM tableA, tableB
    Where tableA.x (+) = tableB.y
    Outer Join

    Plus symbol on the deficient side
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width