FROM table1LEFT JOIN table3 ON table2.key = table3.keyFROM table1 LEFT JOIN table3ON table1.key = table2我决定添加一个更复杂的第二类示例:
SELECT table1.Name AS MainData, table3P
我想使用join和left join来显示我的数据库。但看起来效果不太好。pdt.ProductName,dbpjs.CodeName,ordercustline.id as oid, pdt.LanguageID LEFT JOINproducts ON products.id = ordercustline.ProductID JO
我稍微修改了一下PostgreSQL中的连接理论,但找不到我通常使用的语法:JOIN TABLE_B B ON (A.COLUMN_A = B.COLUMN_BSELECT * FROM TABLE_A A
INNER JOIN TABLE_B B ON (A.COLUMN_A = B.COLUMN_B) [WHERE ..]