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 ; ON Answers.qkey = Questions.qkey ; LEFT OUTER JOIN .\kbdata\knowledge!kbusers kbAnsU ; ON Answers.UserKey = KBAnsU.UserKey ; INNER JOIN .\kbdata\knowledge!kbcats; ON Questions.catkey = Kbcats.catkey ; INNER JOIN .\kbdata\knowledge!kbfirms; ON Questions.firmkey = Kbfirms.firmkey ; LEFT OUTER JOIN .\kbdata\knowledge!kbusers; ON Questions.userkey = kbusers.userkey ; WHERE Questions.firmkey = lcFirmKey ; ORDER BY CatName, Questions.qkey, QDate ; INTO CURSOR TQuery