Union query in mysql

Question

Hi,

I have 2 tables catelog and catelog copy. And, I need to to display both these table fields as one table using mysql.

Can anyone correct this code for joining 2 tables?

$result = mysql_query("SELECT * FROM catelog WHERE title='".$fileid."'union
select status  from catelog_copy " );

Answer 1

You could simply use

SELECT c1.*, c2.* FROM catalog as C1, catalog_copy as C2
where c1.Title = 'blah'

if no logic combining the results is required. But that seems silly...

What i think you want to do is

( select * from catalog 
  where Title = 'title' )
union
( select * from catalog_copy   
  where Title = 'title')

Answer 2

SELECT statements you'd like to UNION have to return the same number of columns and types of those columns should match.

So

SELECT a, b, c FROM table1 UNION SELECT a, b, c FROM table2

will work, but

SELECT a, b FROM table1 UNION SELECT a, b, c FROM table2

will not.

Names of the fields and the fields themselves might be different though.