lcFirmKey = "00000000" SELECT Questions.qkey, Answers.akey, Answers.adate, Answers.answer,; Answers.seealso, Questions.firmkey, Questions.catkey, Questions.qdate,; Questions.question, Kbcats.catname, Kbusers.username AS Q_By_Name, ; Kbusers.userkey AS Q_By_Key, KBAnsU.UserName AS A_By, ; KBAnsU.userkey AS A_By_Key; FROM .\kbdata\knowledge!answers RIGHT OUTER JOIN .\kbdata\knowledge!questions ; INNER JOIN .\kbdata\knowledge!kbcats; INNER JOIN .\kbdata\knowledge!kbfirms; LEFT OUTER JOIN .\kbdata\knowledge!kbusers; LEFT OUTER JOIN .\kbdata\knowledge!kbusers kbAnsU ; ON Answers.UserKey = KBAnsU.UserKey ; ON Questions.userkey = kbusers.userkey ; ON Questions.firmkey = Kbfirms.firmkey ; ON Questions.catkey = Kbcats.catkey ; ON Answers.qkey = Questions.qkey ; WHERE Questions.firmkey = lcFirmKey ; ORDER BY CatName, Questions.qkey, QDate ; INTO CURSOR TQuery BROWSETIA