Sql server With

with HostDevice as (----商户主机
select TerminalID ,Deviceid hostDeviceid ,Device.ModelID,Device.SN HostSN,Device.MerchantID,Device.InstallAddress,Device.SoftVersion
from Device
join model HostM on Device.ModelID=HostM.ModelID and HostM.Category in(0,3,4,5,6,8)
--where TerminalID is not null
) ,--------商户密码键盘
keyBoardDevice as (
select TerminalID ,Deviceid  keyBoardDeviceId ,Device.SN keyBoardSn
from Device
join model keyBoardM on Device.ModelID=keyBoardM.ModelID and keyBoardM.Category in(2,7)
--where TerminalID is not null
)
select * from keyBoardDevice