父子查询的sql

以 sqlserver为例

 

父表 

       CREATE TABLE [dbo].[type] (
 [typeid] [bigint] IDENTITY (1, 1) NOT NULL ,
 [typename] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO

子表

      CREATE TABLE [dbo].[border] (
 [borderid] [bigint] IDENTITY (1, 1) NOT NULL ,
 [typeid] [bigint] NOT NULL ,
 [bordername] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO

 

查询语句

   select t.typename as 父,b.bordername as 子  from border b left join type t on t.typeid = b.typeid group by t.typename,b.bordername