View Single Post
  #3 (permalink)  
Old October 22nd, 2004, 03:22 AM
dcb22 dcb22 is offline
Registered User
Join Date: Oct 2004
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts

Thanks for the reply. I think that's almost there but the trouble is the date is stored in a field in each of the 3 foreign tables! I need to join the data kind of into one table and then do a sort on the "date column", hope that makes sense! Only getting future records in mysql is easy because I can then do [datecol] > NOW(). But it's just getting the data from all 3 of the foreign tables and then doing the sort.

thanks again,