select p.prodid, p.product, p.shortdesc, s.skuid, s.sku, s.skudesc, s.systemSkuDesc, pkg.scc14, pkg.master_unit_desc, s.packsizedesc, pkg.master_unit_qty, pkg.master_unit_size, pkg.master_unit_size_measure, pkg.master_gross_weight, pkg.master_gross_weight_unit, pkg.master_net_weight, pkg.master_net_weight_unit, pkg.master_net_weight_type, pkg.scc14 from tbl_PRD_Skus s left outer join tbl_PRD_Products p on s.prodid = p.prodid left outer join tbl_PRD_Packaging pkg on s.skuid = pkg.linkid and pkg.linkType = 'SKU' where s.ownerid = 67 and s.fsl_tableCode = 'MFR' and s.dataLevel = 0 and s.GS1_SyncDate IS NOT NULL order by p.product, s.sku