Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jtrapat1
Starting Member
43 Posts |
 Posted - 2001-10-15 : 10:11:05
|
| I'm using SQL Server 7 and Crystal Reports 8.5. I need help writing a subquery with the following SQL statement:----------------The problem is that, for my BillAssignments.Analyst field,I also need to add this same field into this query for the following condition:(SELECT Bill.BillNum,BillAssignments.Analyst AS PrimaryAnalystFROM Bill LEFT JOIN BillAssignments ON Bill.BillNum = BillAssignments.BillNumWHERE BillAssignments.Priority =1)This way, I can drag both fields in to my report and group them by two fields; an outer group by Primary Analyst and an inner group by Analyst.How can I include this field in my query twice? Thanks in Advance.John ---------SELECT TOP 100 PERCENT Bill.BillNum, Bill.Sponsor, Bill.Title, Bill.OriginalCommittee, Bill.CommitteeDate, Bill.BAMCode, Bill.BillMemoCode, CommitteeActions.ActionCode, BillAssignments.Analyst, Bill.Bill99Code, Bill.SenateNum, Requests.Requester,Requests.Comments,BillAssignments.Priority,Privilege.InitialsFROM Bill LEFT JOIN BillAssignments ON Bill.BillNum = BillAssignments.BillNum LEFT JOIN Requests ON Bill.BillNum = Requests.BillNumLEFT JOIN CommitteeActions ON Bill.BillNum = CommitteeActions.BillNum LEFT JOIN BillComment ON Bill.BillNum = BillComment.BillNum LEFT JOIN Privilege ON BillAssignments.Analyst = Privilege.UsernameWHERE(Requests.BillNum IS NOT NULL) OR (Bill.Sponsor <> 'Budget') AND (Bill.Bill99Code = 'Y') AND (CommitteeActions.ActionCode IS NULL) OR (Bill.Sponsor <> 'Budget') AND (CommitteeActions.ActionCode IS NULL) AND (Bill.InWAM = 'Y') AND (Bill.BAMCode IN ('R', 'X', 'U'))ORDER BY BillAssignments.Analyst,Bill.BillNum, BillAssignments.Priority |
|
|
|
|
|
|
|
Need Help Writing Subquery