Link to home
Start Free TrialLog in
Avatar of gdunn59
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'

Open in new window

Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Not a Teradata person but everything I can find on the SQL, it is similar to any other SQL.

What do the braces "{}" and "oj" do?  I cannot find anything with that syntax online.
ASKER CERTIFIED SOLUTION
Avatar of awking00
awking00
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial