help with sql query

Lets assume i have ' employee_Id ' column in table employeesIBM , and 'employee_Id' column in employeesSUN.

Now,

Lets once again assume,that there are 4 records in employeesIBM.

and 10 records in employeesSUN.

*******What i want to achieve*****

i want to write a query which will display one column 'ALLemployees'

displaying 4 records of employeesIBM and 2 records in employeesSUN.

something like this >>>

employee_Id ******from employeesIBM table

1

2

3

4

employee_Id ******from employeesSUN table

10

11

want to write a query which will display something like this

ALLemployees

1

2

3

4

10

11

Please help me out with this.

Kris



Answer this question

help with sql query

  • Rebecca Karma

    Made another post about this at:

    http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=424936&SiteID=1

    PS. Prolly better if you only post in one place. For questions of this sort I think the Transact-SQL forum would be better suited.

    Ta.


  • help with sql query