SettingLib/SQL/ACASetting.sql

-- Active: 1751960213665@@192.1.2.61@5236@EQM_CESHI



#对比项通道关联表
SELECT *
FROM tACACompareItemRoad;


SELECT *
FROM tServiceSetInfo;


#对比项表
SELECT *
FROM tACACompareItems;

#获取所有的对比项信息
SELECT *
FROM tACACompareItems
LEFT JOIN tACACompareItemRoad ON tACACompareItems.ItemID = tACACompareItemRoad.ItemID;

#只获取对比项信息
SELECT *
FROM tACACompareItems;

#获取对比项的通道信息
SELECT *
FROM tACACompareItemRoad;