Hi all,
I'm trying to understand the code below, with (+). Comming from MS-SQL server, I never seem this before. Can some explain what the (+) does?
thanks
SELECT
tblA.FIRST_NAME,
tblA.lAST_NAME,
tblA.STREET_NUMBER,
btlA.CITY
FROM
tblA,
tblB
WHERE
LAST_NAME LIKE 'TRAN%'
and
tbla.CODE = tblB.CODE
SELECT
tblA.FIRST_NAME,
tblA.lAST_NAME,
tblA.STREET_NUMBER,
btlA.CITY
FROM
tblA,
tblB
WHERE
LAST_NAME LIKE 'TRAN%'
and
tbla.CODE = tblB.CODE(+)
I'm trying to understand the code below, with (+). Comming from MS-SQL server, I never seem this before. Can some explain what the (+) does?
thanks
SELECT
tblA.FIRST_NAME,
tblA.lAST_NAME,
tblA.STREET_NUMBER,
btlA.CITY
FROM
tblA,
tblB
WHERE
LAST_NAME LIKE 'TRAN%'
and
tbla.CODE = tblB.CODE
SELECT
tblA.FIRST_NAME,
tblA.lAST_NAME,
tblA.STREET_NUMBER,
btlA.CITY
FROM
tblA,
tblB
WHERE
LAST_NAME LIKE 'TRAN%'
and
tbla.CODE = tblB.CODE(+)