MySQL Forums
Forum List  »  Newbie

Re: Combine couple of tables into one table by using references
Posted by: Peter Brawley
Date: August 03, 2016 02:30PM

After ...

create or rpelace view master as
select a,b,c from a
union -- TO SHOW DUPES, ADD ALL
select a,b,c from b;

... then ...

select a,b,c fro master;

gets you everything in a and b

Options: ReplyQuote


Subject
Written By
Posted
Re: Combine couple of tables into one table by using references
August 03, 2016 02:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.