两个相关联表
TblRecords
的判定规则
字段与TblRule
的id
字段关联
CREATE TABLE [dbo].[TblRule](
[Id] [bigint] IDENTITY(1,1) NOT NULL,
[厚度_min] [float] NOT NULL,
[厚度_max] [float] NOT NULL,
[平均厚度_min] [float] NOT NULL,
[平均厚度_max] [float] NOT NULL,
[重量_min] [float] NOT NULL,
[重量_max] [float] NOT NULL,
[平均重量_min] [float] NOT NULL,
[平均重量_max] [float] NOT NULL,
[密度_min] [float] NOT NULL,
[密度_max] [float] NOT NULL,
[密度_avg] [float] NOT NULL,
[检测数量] [int] NULL,
[UserId] [bigint] NOT NULL,
[创建日期] [datetime] NULL,
[修改日期] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[TblRecords](
[Id] [bigint] IDENTITY(1,1) NOT NULL,
[UserId] [bigint] NULL,
[判定规则] [bigint] NULL,
[检测时间] [datetime] NULL,
[药片批号] [nvarchar](22) NOT NULL,
[厚度] [float] NULL,
[重量] [float] NULL,
[密度] [float] NULL,
[温度] [float] NULL,
[介质密度] [float] NULL,
[存储报表] [int] NULL,
PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
已知TblRecords
的id
时查询对应的规则语句
select * from TblRule where id in (select T1.[判定规则] from TblRecords as T1 where id=ID值)