adding the results of a number of calls to mysql_query

system: win NT4 server (IIS4, php4) Problem: I'm writing a web front end to an old in house access database with tables split over years (rather than the row having what year it's in) i.e. table00_01 table 99_98 etc etc ideally I'd like to run the same query against each table and the fetch rows form it the result of all the queries. any ideas on how I can do this ? with thanks Christian Christian Cable ICT Assistant Careers Service; Lancaster University Tel: (01524) 594072 Fax: (01524) 592072 http://www.lancs.ac.uk/staff/cable/