gdunn59
asked on
New at Teradata Queries - getting an error Missing Right Parenthesis also not sure if I want an outer join or inner join
I'm new at creating queries in Teradata. The query I created is giving me an error that there is a right parenthesis missing. Also, I'm not quite sure if I want an outer join or inner join.
select DISTINCT
facets.CMC_PRPR_PROV.PRPR_ID,
facets.CMC_PRPR_PROV.PRPR_NAME,
facets.CMC_CLCL_Claim.PRPR_ID
FROM
{ oj FACETS.CMC_CLCL_CLAIM
LEFT OUTER JOIN
FACETS.CMC_PRPR_PROV ON FACETS.CMC_CLCL_CLAIM.PRPR_ID = FACETS.CMC_PRPR_PROV.PRPR_ID }
where FACETS.CMMC_PRPR_PROV.PRPR_ID = '0000000'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What do the braces "{}" and "oj" do? I cannot find anything with that syntax online.