select
instname=(select stname from tbstore where tbsale.instno=tbstort.stno),
outstname=(select stname from tbstore where tbsale.outstno=tbstort.stno)
from tasale
instname=(select stname from tbstore where tbsale.instno=tbstort.stno),
outstname=(select stname from tbstore where tbsale.outstno=tbstort.stno)
from tasale
select b.name instname, c.name outstname from tbsale a, tbstore b, tbstore c where a.instno=b.no and a.outstno=c.no
比較麻煩
學習
更新一下表,update table tasalemx set instno="仓库1" where instno="0001"
其他也一样
打开tbsale表时,增加两个LOOKUP字段获取其名称。。
详细一点,OK?