SELECT num,name,address from table2
where num in (SELECT friendnum FROM table1 WHERE mynum='10001') or num='10001';把10001替换成程序变量就行了。
where num in (SELECT friendnum FROM table1 WHERE mynum='10001') or num='10001';把10001替换成程序变量就行了。
散分!!!