新手，请问_PB

新手，请教
查询结果如下
1035 1871
1872
1873
10351 1871
1872
1873
10352 1871
1872
1873
怎么改为
1035 1871
10351 1872
10352 1873
让2列不需要对应

------解决方案--------------------
1035 1871
1035 1872
1035 1873
10351 1871
10351 1872
10351 1873
10352 1871
10352 1872
10352 1873

你想得到

1035 1871
10351 1872
10352 1873

这是什么关系？各取一个？
------解决方案--------------------

SQL code

--帮你捋下表ta10567 103510567 1035110567 10352表tc10567 187110567 187210567 1873你想得到的结果？10567 1035 187110567 10351 187210567 10352 1873--本身一个表，你把它拆开了，现在又要凑一个表
------解决方案--------------------
select ta.gz,ta.ycode,tc.gh from 
(select gz,ycode from commod)ta,
(select gz,gh from per_main)tc
where ta.gz=tc.gz and (right(ta.ycode,1) = right(tc.gh,1))

------解决方案--------------------
探讨
select ta.gz,ta.ycode,tc.gh from  
(select gz,ycode from commod)ta,
(select gz,gh from per_main)tc
where ta.gz=tc.gz and (right(ta.ycode,1) = right(tc.gh,1))