How to map data from two columns of a table to one

[Shahzad_Ahsan]

Hi Freinds

I am stuck in a problem.

I have two tables. lets say T1 and T2 like this

T1:

SubId	MainId
0	1
0	2
0	3
9	4
10	5
0	6

T2:

MainId

1

2

3

4

5

6

Result I need:

MainId
1
2
3
4
5
6
9
10

I want to get all the values from  "SubId" which are not 0 in the new table.

Thank You

[skamath1]

The requirement is not clear. Should the field name in T2 be SubId and the result table should be SubId instead of MainId?