create new table from a union join 1

[guitardave78]

Hi all.
I have a query that uses a union join to create a set of records.
Is there an easy way to create a new table based on this data?

Thanks

}...the bane of my life!

http://www.yetanotherreviewsite.co.uk

http://www.fuzzyd.co.uk

 

[r937]

create table foo
select stuff from t1
union all
select stuff from t2

r937.com | rudy.ca

 

[guitardave78]

Thanks, i had brackets that were wrong lol.
Need to get mysql 5 and just use a view me finks!!

}...the bane of my life!

http://www.yetanotherreviewsite.co.uk

http://www.fuzzyd.co.uk