RE: [PHP-DB] adding the results of a number of calls to mysql_que ry

thanks for the idea but it was a bit too of a headache in my case as I was generating the sql statement in a messy way tho lots of bits of code. Reading an oracle book I came across unions and that has led me onto what I think will solve my prob merged tables I'm going try create table alltables (blah blah...) type=MERGE UNION (table00_01, table99_98 etc etc) thansk for everyone who gave me hints cheers Christian On Monday, September 24, 2001 10:54 AM, Russ Michell [SMTP:r.j.michell@apu.ac.uk] wrote: > If I have the right end of the stick you want: > > SELECT * FROM table99_98,table00_01 WHERE table99_98.foo='$bar' AND table00_01.foo='$bar'; > > Russ >