Smart3D中等级数据SQL查询（）

📅 2022-10-27 👤 pipingpig 📁 Smart3D , 模型视图 ✏️ 更新于 2026-08-20 👁 2 💬 0

select * from XPipeSpecContainsPartSpecs

select * from JDPipeSpec

select * from JDPipePartSpec

select * from JDPipeSpec j1

join XPipeSpecContainsPartSpecs j2 on j2.oidorigin = j1.oid

join JDPipePartSpec j3 on j3.Oid=j2.OidDestination

select j1.SpecName,j3.ShortCode,j3.OptionCode,j3.FirstSizeFrom,j3.FirstSizeTo,j3.SecondSizeFrom,j3.SecondSizeTo,j3.CommodityCode from JDPipeSpec j1

join XPipeSpecContainsPartSpecs j2 on j2.oidorigin = j1.oid

join JDPipePartSpec j3 on j3.Oid=j2.OidDestination