PostgreSQL INNER JOIN与WHERE子句连接 [英] PostgreSQL INNER JOIN vs WHERE clause join
本文介绍了PostgreSQL INNER JOIN与WHERE子句连接的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我认为INNER JOIN等同于WHERE子句中的JOIN.当我使用WHERE子句进行联接时,我得到返回的行.但是,如果我执行INNER JOIN,则不会输出任何行.我得到没有匹配的结果.我误会了,或者我做错了什么?
I thought INNER JOIN was equivalent to JOIN in WHERE clause. When I make join using WHERE clause, I get rows returned. But if I do INNER JOIN, then no rows are outputed. I get result that there are no matches. Am I mistaken, or I'm doing something wrong?
这些联接等效吗?:
INNNER JOIN:
INNNER JOIN:
account_move_reconcile_line_applied amrla
INNER JOIN account_move_reconcile_line amrl ON (amrla.credit_line_id = amrl.id)
INNER JOIN account_move_reconcile amr ON (amrl.credit_reconcile_id = amr.id)
INNER JOIN account_move_line aml ON (aml.reconcile_partial_id = amr.id)
INNER JOIN res_partner rp ON (aml.partner_id = rp.id)
IN WHERE子句:
IN WHERE clause:
amrla.credit_line_id = amrl.id
and amrl.partner_id = rp.id
and amrl.credit_reconcile_id = amr.id
and aml.reconcile_id = amr.id
推荐答案
ID错误:
INNER JOIN account_move_line aml ON (aml.reconcile_partial_id = amr.id)
它应该是reconcile_id而不是reconcile_partial_id.
It should have been reconcile_id instead of reconcile_partial_id.
这篇关于PostgreSQL INNER JOIN与WHERE子句连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文