# 单一资料库处理条件不足 !

Posted by 安宝 on June 21, 1999 at 17:34:58:

In Reply to: Re: DB不同方法各异哦!(请问) posted by 皮皮 on June 21, 1999 at 16:52:53:

SELECT detail.RECIPEID, detail.TRACKOUTTI,
detail.LOTID, aoi.TRACKOUTTI AS Expr1,
aoi.LOTID AS Expr2
FROM detail, aoi
WHERE detail.LOTID = aoi.LOTID AND (detail.RECIPEID
LIKE 'AO001.%1') AND (aoi.TRACKOUTTI IS
NULL)

问题1. 选入五个资料栏转入一个资料栏 (f1 & f2 & ...) ?
问题2. 新增或是修改 ? (Insert/Update...)
问题3. 单一资料库 (aoi) 转入条件为何 (LOTID)?

Follow Ups:

- Re: 单一资料库处理条件不足 Sorry,再请教 皮皮 17:49:00 6/21/99 (4)
  - Re: 单一资料库处理条件不足 Sorry,再请教 安宝 18:15:22 6/21/99 (3)
    - 请问 " 无数值提供给一或多个必要参数" ??? 皮皮 09:53:41 6/22/99 (2)
      - 只能建议 ... 安宝 11:15:14 6/22/99 (1)
        - 谢谢安宝,vb6之updat指令好像不支援其他Table,我已用他法解决.(无内文) 皮皮 11:54:21 6/22/99 (0)