SQL Language (MOSC)

MOSC Banner

Left outer join not working

in SQL Language (MOSC) 4 commentsAnswered

Oracle database 19c on Solaris

SQL:

SELECT s.*, a.Profit_no, a.Send_to_adtrack, ms.Mod_size_desc, m.Acct_no, m.F_name, m.L_name, ts.Adt_status_color, ts.Adt_status_desc 

FROM arad_alt_size s, arad a, armaster m, armodular_size ms 

LEFT JOIN aradt_status ts 

ON ts.Adt_status = s.adt_status

WHERE s.Ad_no = a.Ad_no

AND a.Acct_no = m.Acct_no 

AND s.Alt_mod_size = ms.Mod_size_code 

AND s.Ad_no = 326469;



Error message:

ORA-00904: "S"."ADT_STATUS": invalid identifier

00904. 00000 - "%s: invalid identifier"

*Cause:   

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center