[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
Robin Cornelius wrote: > Eg i now get > > Seminar 1 > Seminar 2 > Seminar 4 paper due > Seminar 3 > > but no seminar 4 > > Is this possible from a single query, or do a need to generate a temp > table first with somthing like:- off the top of my head logic not > valid SQL Good point. Perhaps the easiest approach is to create a temporary table to hold all the information you actually want, then run two inserts into that table, one for the paper due dates should they exist and the other for the seminar dates, and then read the temporary table in date order. James -- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html