[EMAIL PROTECTED] writes:
>The query I sent works...but I need additional info from a CDStatus
>table, but like I said it has multiple records per CDApplcationID from
>these multiple records I need the record that has the MAX ReviewType for
>each CDApplicationID...make sense???
What if you added Max(CDStatus.ReviewType) and whatever other fields you
need from CDStatus to your select statement ...
SELECT CDApplication.ProjectName, CDApplication.Applicant,
CDApplication.Location AS Property,
CDApplication.ProjectNumber, LookupCDStatus.Desc,
CDStatus.OtherNeededData, Max(CDStatus.ReviewType)
... then list all of those same fields (except ReviewType) in a GROUP BY
line?
Carolyn
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- (SOLVED) sql question Tony Weeg
- RE: (SOLVED) sql ques... Paul Vernon
- RE: (SOLVED) sql ques... Greg Luce
- sql question John mccosker
- Re: sql question Adrocknaphobia
- Re: sql question John mccosker
- RE: SQL QUESTION Bruce, Rodney S HQISEC/Veridian IT Services
- SQL Question Kelly Keith
- RE: SQL Question Burns, John D
- RE: SQL Question Kelly Keith
- sql question Carolyn Foster
- sql question Tony Weeg
- Re: sql question Ian Potts
- RE: sql question Dave Watts
- Re: sql question Dick Applebaum
- RE: sql question Ryan Duckworth
- RE: sql question Tony Weeg
- Re: sql question Joe Rinehart
- sql question Tony Weeg
- Re: sql question Thomas Chiverton
- Re: sql question Stephen Moretti (cfmaster)