34,571
社区成员
发帖
与我相关
我的任务
分享
select S_CusClass,
S_InvClass,
M_Rate
from 对照表 a
inner join 客户表 b on a.S_InvClass=b.S_Class and a.S_CusClass=b.S_Code
where b.S_Code='001' and S_Code='001'
select 对照表.M_Rate(折扣) from 对照表 a
join 存货表 b on a.S_CusClass = b.S_Code
join 客户表 c on a.S_InvClass = c.S_Code
join 客户分类表 d on c.S_Code=d.S_Code
where a.S_Code='A' AND c.S_Code='001' and d.S_Name='L2'
select 对照表.M_Rate(折扣) from 对照表 a
join 存货表 b on a.S_CusClass = b.S_Code
join 客户表 c on a.S_InvClass = c.S_Code
join 客户分类表 d on c.S_Code=d.S_Code
where a.S_Code='A' AND c.S_Code='001' and d.S_Name='L2'
SELECT c.M_Rate
FROM 客户表 a inner join 客户分类表 b on b.S_Code=a.S_Class
inner join 对照表 c on c.S_CusClass=b.S_Code
inner join 存货分类表 d on c.S_InvClass=d.S_Code
inner join 存货表 e on e.S_Class=d.S_Code
where e.S_Name='电脑' and a.S_Name='张三'
SELECT *
FROM 存货 T1
INNER JOIN 对照表 t2
ON t1.S_Class = t2.S_CusClass
INNER JOIN 客户表 t3
ON t2.S_InvClass = t3.S_Class
WHERE T1.S_Code='A' AND T3.S_Code='001'
select 对照表.M_Rate(折扣) from 对照表 a
join 存货表 b on a.S_CusClass = b.S_Code
join 客户表 c in a.S_InvClass = c.S_Code
WHERE...