一直等：sql出现问题：标示符无效，请帮忙看看。

Question

sql脚本如下：

select invoice_code,
money,
business_date,
maker.docname pk_maker,
place.docname pk_place,
verification_status,
invoice_type,
verification_date
from ((select h.pk_corp,
bill_code,
invoice_code,
money,
business_date,
b.pk_maker,
pk_place,
verification_status,
invoice_type,
verification_date
from gh_invoice_yandb_b b, gh_invoice_yandb h
where h.pk_invoice = b.pk_invoice
and (h.dr = 0)) union
(select h.pk_corp,
bill_code,
invoice_code,
money,
business_date,
b.pk_maker,
pk_place,
verification_status,
invoice_type,
verification_date
from gh_invoice_green_b b, gh_invoice_green h
where h.pk_invoice = b.pk_invoice
and (h.dr = 0))) invoice,
bd_defdoc maker,
bd_defdoc place
where [b]maker.pk_psndoc(+) = invoice.pk_maker[/b]
and [b]place.pk_psndoc(+) = invoice.pk_place[/b]

提示加粗处："place"."pk_psndoc"标识符无效。
如果把最后的where和and去掉没有问题，但是我需要进行过滤。
请问大侠，如果修改？

Answer 1

bd_defdoc 这个表没有 pk_psndoc 字段 看看哪个字母写错了