Recent content by evarod

There was a typo in my post. it is correct in the query. i corrected it. I was just trying to make the actual query more generic for public view.

I am trying to union results from 2 tables that return uneven columns. I am missing exit_date, school_year and reason from the 2nd results. and filling in with '' as column_name or null as column_name isn't working. What would be the syntax? Error Message: [HY000][-20081]...