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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-15 : 17:14:31
|
| John writes "I'm using VB6, Crystal Reports 8.5, and a backend database of MS SQL Server 7.I need help in writing a subquery in order to format a Crystal Report with a one-to-many relation column.----------Here's the original SQL query with criteria:(the key field here is BillAssignments.Analyst)----------------CREATE VIEW rptvwMyviewAS 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 ----------------------And here's the SELECT query I need to add:(SELECT Analyst FROM BillAssignments WHERE BillAssignments.Priority = '1')----I'd like this to be another column in the above query but I'm not very familiar with inner queries or subqueries.Thanks in advance.John" |
|
|
|
|
|
|
|
Help Writing Subquery