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???
Kelly
-----Original Message-----
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 21, 2004 1:54 PM
To: CF-Talk
Subject: RE: SQL Question
Outer join? I don't quite understand what you're asking. Does
the
query you sent work?
John
-----Original Message-----
From: Kelly Keith [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 21, 2004 3:52 PM
To: CF-Talk
Subject: SQL Question
I need some help...I am very stumped....
I am trying to pull info from a couple different tables....and
it is
fairly involved...
SELECT CDApplication.ProjectName, CDApplication.Applicant,
CDApplication.Location AS Property,
CDApplication.ProjectNumber,
LookupCDStatus.Desc
FROM CDApplication INNER JOIN
CDStatus ON CDApplication.RecordID =
CDStatus.CDApplicationID INNER JOIN
LookupCDStatus ON CDApplication.Status =
LookupCDStatus.Code AND CDStatus.Type = LookupCDStatus.Code
WHERE (CDApplication.DateAppcn BETWEEN CONVERT(DATETIME,
'2004-01-01
00:00:00', 102) AND CONVERT(DATETIME, '2004-04-20 00:00:00',
102))
AND (NOT (CDApplication.Status = '190')
OR CDApplication.Status = '200')
AND (dbo.CDApplication.ProjectNumber LIKE
'SDMA%'
OR CDApplication.ProjectNumber = 'SDMI%'
OR CDApplication.ProjectNumber = 'ASC%'
OR CDApplication.ProjectNumber = 'SPCD%')
The kicker is that I have another table called CDStatus and
there are
multiple records per CDApplicationID (CDApplication.RecordID)
depending
on ReviewType (which is a code). I need to get data out of that
table
that matches a specific CDApplicationID where it is the MAX
ReviewType.
Make sense?? Is it possible?
I am working with SQL Server 2000....
Anything would be helpful...
Thanks.
Kelly
________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
