Brian Cummiskey wrote: > left outer join table 4 on table1.skuid = table4.skuid Just to correct my typo on this line: left outer join table4 on table1.skuid = table4.skuid .....................^ no space :)