如一张表ps_head_a里同时保存两个都是仓库编号的字段ckid,aim_ckid,一个是发货仓库的(ckid),别一个是收货仓库的(aim_ckid),仓库的名称和编号都在别外一张表里如baseck,(ckid仓库编号,ckname 仓库名称)
如何将它们两个仓库的内容只用sql语句同时都显示出来,我只会显示出一个仓库的内容
select b.ckname from ps_head_a as a,BaseCK as b where a.ckid=b.ckid"
有没有办法只用sql语句同时都把两个仓库的名称显示出来
如何将它们两个仓库的内容只用sql语句同时都显示出来,我只会显示出一个仓库的内容
select b.ckname from ps_head_a as a,BaseCK as b where a.ckid=b.ckid"
有没有办法只用sql语句同时都把两个仓库的名称显示出来
FROM ps_head A INNER JOIN
baseck B ON A.ckid= B.ckidINNER JOIN
baseck C ON A.aim_ckid= C.ckid
FROM ps_head A INNER JOIN
baseck B ON A.ckid= B.ckid INNER JOIN
baseck C ON A.aim_ckid= C.ckid
(select ckname from BaseCK where BaseCK.ckid=a.aim_ckid) as 收货仓库name
from ps_head_a a