RE: SQL Question

[Burns, John D]

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]

---