MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

get same column values from different table
Posted by: MANMUTHU KARUPPANNAN
Date: September 11, 2015 04:03AM

Hi,

I am trying to get same field name from different tables.
And i am using like the below query to get the field name.
I am expecting some other queries to get distinct 'function_name' column from 'N' of tables.

SELECT function_name
FROM base_table
UNION
SELECT function_name
FROM firstcall_table
UNION
SELECT function_name
FROM secondcall_table

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
get same column values from different table
MANMUTHU KARUPPANNAN
September 11, 2015 04:03AM
Re: get same column values from different table
Peter Brawley
September 11, 2015 11:41AM


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.