Question:

What is the command to list the values of a common column from the tables in the sql server2005?

by  |  earlier

0 LIKES UnLike

i created a database in which there are many tables with same fields.now i want to know the command that will display the values of that column from the database

 Tags:

   Report

1 ANSWERS


  1. Select common_column from table1

    union all

    Select common_column from table2

    ...

    union all

    Select common_column from tableN

Question Stats

Latest activity: earlier.
This question has 1 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.