SELECT t.Description, m.memoData, upper(t.description) descriptionSearch FROM tbl_PRD_Memo m, tbl_PRD_MemoTypes t WHERE m.LinkID = AND m.LinkType = 'SKU' AND m.OwnerID = AND m.FSL_TableCode = AND m.memoType = t.Code ORDER BY Code SELECT t.Description, m.memoData, upper(t.description) descriptionSearch FROM tbl_PRD_Skus s INNER JOIN tbl_PRD_Products p ON (s.ProdID = p.Prodid) INNER JOIN tbl_PRD_Memo m ON (p.prodid = m.LinkID AND m.LinkType = 'PRD') INNER JOIN tbl_PRD_MemoTypes t ON (m.memoType = t.Code) AND s.OwnerID = AND s.FSL_TableCode = AND s.SkuID = SELECT descriptionSearch FROM NewQuery WHERE descriptionSearch = '#qmd_dispProdMemoData.descriptionSearch#';