I'm trying to do a query in mysql whose results I want to put in another mysql database/table. The query part I have that correct as the results are right, from there I'm lost. Does anyone know who this is suppose to work? is it the SELECT .... INSERT syntax? Thanks -- Jon Miller <jlmiller at mmtnetworks.com.au> MMT Networks Pty Ltd