Re: Can't get my query to return wanted data

On Fri, 19 Jan 2018 11:25:42 -0500, shawn l.green wrote: > Hello Chris, > > On 1/19/2018 12:50 AM, Chris Roy-Smith wrote: >> Hi I am running mysql 5.7.20 in ubuntu linux 17.10 >> >> I have 2 tables, member and status with contents like >> >> member: >&

Can't get my query to return wanted data

for a selected year. select details.ident, given, surname from details left join status on details.ident = status.ident where NOT EXISTS (select year from status where (status.year = 2018) and (details.ident = status.ident) ) Thank you for looking at this. regards, Chris Roy-Smith -- MySQL General