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:[EMAIL PROTECTED]] 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
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]