missing dates on query output.

This question is also posted to StackOverflow here: http://stackoverflow.com/questions/39082069/missing-dates-on-query-output

You are lucky. Looking again at your query, I am surprised it gave you any result at all. It needs to be improved some more after you apply the suggestions from WolfShade and EddieLotter.

You should:

1) qualify all column names with the respective table name followed by a dot;

2) move the meedate condition to the WHERE clause;

3) avoid givig a table and a column the same name, squadlt.

The same query would then end up looking like the following (I have guessed which columns beloong to which tables):

SELECT name.Stuid, trim(concat(name.fname,' ',name.lname)) AS OVER_30_Days, name.ltfname as instructor, Max(meeting.meedate) as maxMeeDate

FROM name 

LEFT JOIN meeting ON meeting.meeStuid = name.Stuid

LEFT JOIN squadlt ON squadlt.squadlt = name.ltid

WHERE meeting.meeStuid is null

AND meeting.meedate BETWEEN DATEADD(day,-31,NOW()) AND NOW()

AND  name.type = 'pupil'

AND name.city = 'jackson'

AND name.status = 'a'

AND name.Stuid <> '432'

AND name.Stuid <> '5'

AND name.Stuid <> '183' 

ORDER BY name.ltfname, OVER_30_Days

I suspect you have a problem with your joins. Try changing "name LEFT JOIN meeting" to "name RIGHT JOIN meeting" and see if you get what you expect.

Cheers

Eddie

I don't know what database you're using, but in Oracle, if you do a MAX(anything) without giving it an alias, it just shows up as an undefined column.  Try:

SELECT Stuid, trim(concat(name.fname,' ',name.lname)) AS OVER_30_Days, ltfname as instructor,

     Max(meedate) as meedate

FROM name LEFT JOIN meeting ON meeStuid = Stuid

HTH,

^_^

PS.. it's too late, I'm sure, but I wouldn't use reserved words for table or column names (you named a table "name".)

What about something like

and meedate BETWEEN DATEADD(day,-31,NOW()) AND NOW()