-
Sep 24th, 2020, 02:58 PM
#1
[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.
-
Sep 24th, 2020, 03:01 PM
#2
Re: Depreciated Join Syntax
You are correct, it is an Inner Join
-
Sep 24th, 2020, 03:04 PM
#3
Re: Deprecated Join Syntax
-
Sep 25th, 2020, 07:00 AM
#4
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|