向大家请教个sql语句:select placeno,placename,leave as '客户评价结果' from history.评价的结果:0:客户未评价,1:基本满意,2,很满意,3,不满意。history表里面保存的是数字,evalute表里面保存的是数字对应的而字符串(既满意和不满意等).placeinfo表里面保存的是placeno对应的placename,这三个表应该如何连接?
...全文
664打赏收藏
请教一个关于三个表连结查询的sql语句
向大家请教个sql语句:select placeno,placename,leave as '客户评价结果' from history.评价的结果:0:客户未评价,1:基本满意,2,很满意,3,不满意。history表里面保存的是数字,evalute表里面保存的是数字对应的而字符串(既满意和不满意等).placeinfo表里面保存的是placeno对应的placename,这三个表应该如何连接?
select history.placeno, placeinfo.placename, evalute.评价结果
from history inner join placeinfo on history.placeno=placeinfo.placeno
inner join evalute on history.leave=evalute.leave
select h.serviceid as '业务编号',
h.servicename as '业务名称',
h.id as '编号',
h.queueid as '排队序号',
h.queuenumb as '排队号码',
h.getnumtime as '取号时间',
h.operatetime as '呼叫时间',
h.isbook as '是否预约',
h.usercode as '员工工号',
h.username as '员工姓名',
h.windowid as '窗口号',
q.name as '评价结果',
h.overtime as '业务结束时间',
h.dealtype as '处理标示',
h.placeno as '网点名称',
p.placename as '网点编号'
from history as h inner join Placeinfo as p
on
h.placeno = p.placeno
inner join evaluatelevel as q
on h.evaluate = q.pjlevel
SELECT
CASE type
WHEN 'popular_comp' THEN 'Popular Computing'
WHEN 'mod_cook' THEN 'Modern Cooking'
WHEN 'business' THEN 'Business'
WHEN 'psychology' THEN 'Psychology'
WHEN 'trad_cook' THEN 'Traditional Cooking'
ELSE 'Not yet categorized'
END AS Category,
CONVERT(varchar(30), title) AS "Shortened Title",
price AS Price
FROM titles
SELECT product_id,
DECODE (warehouse_id, 1, 'Southlake',
2, 'San Francisco',
3, 'New Jersey',
4, 'Seattle',
'Non-domestic')
"Location of inventory" FROM inventories
WHERE product_id < 1775;
select history.placeno, placeinfo.placename, evalute.评价结果
from history inner join placeinfo on history.placeno=placeinfo.placeno
inner join evalute on history.leave=evalute.leave