Odd problem with using max on a date...
select max(plan->end_date) as 'end' from crew
and
select max(Plan.end_date) as 'end' from crew, plan
does not give the same result... the last one gives me the right max date, but the first one gives a much sooner date.... WHY???
Should this not give the same result ?