請問:
之前拜讀 hagar 的文章,若table的owner為dbo,確實可行,但owner若不是dbo,卻不能讀取,請教以下語法應作何修改...
SELECT DISTINCT c.cust_no, c.state, o.order_no, i.price
FROM ':Local_alias:customer.db' c,
':IB_alias:order' o,
':SYB_alias:lineitem' i
WHERE o.cust_no = c.cust_no AND
o.order_no = i.order_no
曾改為如下,但依然無效.謝謝...
SELECT DISTINCT c.cust_no, c.state, o.order_no, i.price
FROM ':Local_alias:owner:customer.db' c,
':IB_alias:owner.order' o,
':SYB_alias:owner.lineitem' i
WHERE o.cust_no = c.cust_no AND
o.order_no = i.order_no

編輯記錄

找到原因,只需將改帳號所對應之預設結構描述改為真正的owner即可,謝謝大家