sql 一对多表自引用

select [b]distinct[/b] .AreaID,a.AreaName,b.AreaID,b.AreaName,c.AreaID,c.AreaName from [b]表名 1[/b] as a , [b]表名1[/b] as b , [b]表名1[/b] as c , [b]表名2[/b] as pinpai where a.AreaID = big and b.AreaID = M_Sub and c.AreaID = Small and ID=123

返回添加影响行的行号：
insert 表名 (ID,Name,Age) values (1,"hi_beijing",25) SELECT @@IDENTITY as returnID