I have a query that I want to return a field and then a value.
Here is the basic query:
where ABR_ID IN
(SELECT DISTINCT abr_id
WHERE MOCStatus <> 'Inactive' and MOCStatus <> 'Complete'
AND expireyear = '2007')
Order by ABR_ID
What I want to do next is to check a field in the db (tblStatelicense.expirationdate) . It is a date field and I need to check it again today date (getDAte()) and return a value of Y if they have not expired and N if they have expired. There maybe multiple returns for one ID and some of those rows retunred will be expired and some won. But if they have at least on non-expired date then they should get a yes.
so my recordset would be ID Expired
Thanks in advance. Using SQL 2000