sseeley Posted December 31, 2009 Share Posted December 31, 2009 I am hoping somone can help me. I am trying to run a single query (in Crystal Reports) and get two results back, one for a Book A, and the other for Book B. I am struggling to get this data back? SELECT tblfees.feereceived AS "Book A", tblfees.dateadded FROM tblfees JOIN tblfeecategory ON tblfees.fkcategory = tblfeecategory.pkfeecategoryid WHERE tblfeecategory.ccnac = '111111' AND tblfees.feedeleted = 0 UNION SELECT tblfees.feereceived AS "Book B", tblfees.dateadded FROM tblfees JOIN tblfeecategory ON tblfees.fkcategory = tblfeecategory.pkfeecategoryid WHERE tblfeecategory.ccnac = '111112' AND tblfees.feedeleted = 0 Can anyone make any suggestions on how I can get this to work correctly? I am looking for a list of fees for Book A, and a list of fees for Book B Many thanks in advance. Stuart Quote Link to comment Share on other sites More sharing options...
Mchl Posted December 31, 2009 Share Posted December 31, 2009 Does it not work at all (any error messages) or do you get different results from what you expect? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.