Keep getting SQL errors on this SQL Enterprise query what can anyone see that I do not see wrong with this query.
(Select "NV_L2K_PROD"."c_i_itemval"."item_text"
from "NV_L2K_PROD"."lcps"."c_i_itemval"
left join "NV_L2K_PROD"."lcps"."t_license"
On "NV_L2K_PROD"."lcps"."t_license"."license_type" = "NV_L2K_PROD"."lcps"."c_i_itemval"."item_int_code" AND
where ("NV_LK2_PROD"."c_i_itemval"."item_type" = 'license type'
and
"NV_L2K_PROD"."lcps"."c_i_itemval.item_int_code" = "NV_L2K_PROD"."LCPS"."t_license"."license_type")
IP Logged