ERROR 22-322: Syntax error, expecting one of the following: a name, *.

[Citrine10]

hi 

i keep getting errors when trying to join 2 tables: 

ERROR 22-322: Syntax error, expecting one of the following: a name, *.

ERROR 200-322: The symbol is not recognized and will be ignored.

My code:

proc sql;
create table ConsolidatedCust as
(
select *
from customers c, WillWool w
where c.[Cuno] = w.[Cuno]
);
quit;

This is very frustrating. I even tried on top 100 but kept getting the same error. I also tried selecting specific columns but it wouldn't work. Please assist.

[Citrine10]

I also tried this and i would ideally like to go this route of specifying the join. However i still get the same error:
proc sql;
create table ConsolidatedCust as
select *
from WillWool t
left join customers c
on t.[Cuno] = c.cuno
;quit;

[Kurt_Bremser]

from where do you take the idea of the square brackets?

Try this instead:

proc sql;
create table ConsolidatedCust as
  select *
  from customers c, WillWool w
  where c.Cuno = w.Cuno
;
quit;

[Kurt_Bremser · Accepted solution]

Also, please post the complete log of the step by copy/pasting it into a window opened with this button: