Left outer join not working
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: