SELECT Member.FirstName,Member.LastName,Partner.LastUpdated FROM Member;
 JOIN Partner ON Member.Numero = Partner.NoMember AND Partner.Date>ldDate

>I have a subquery that is needed to identify records that should be selected from my main SQL. However, additionally to that process, I also need to extract one field from the sub query. Basically, presently, I have this:
>
>

>SELECT Member.FirstName,Member.LastName FROM Member;
> WHERE Member.Numero IN (SELECT Partner.NoMember AS Numero FROM Partner WHERE Partner.Date>ldDate)
>

>
>But, I would need something like this:
>
>

>SELECT Member.FirstName,Member.LastName,PartnerData.LastUpdated FROM Member;
> WHERE Member.Numero IN (SELECT Partner.NoMember AS Numero,Partner.LastUpdated FROM Partner WHERE Partner.Date>ldDate) AS PartnerData
>

>
>But, as is, this is not supported. How can I adjust?