SELECT * FROM tbl_PRD_Products p INNER JOIN tbl_PRD_Memo m ON (p.prodid = m.linkid AND m.linkType = 'PRD') INNER JOIN tbl_PRD_SKUs s ON (p.prodid = s.prodid) WHERE p.OwnerID = 26 AND p.FSL_TableCode = 'MFR' AND m.MemoType = 'FSE2' AND s.OwnerID = 26 AND s.FSL_TableCode = 'MFR' #getData.prodid#, #getData.shortDESC#, #getData.skuid#, #getData.sku#