我想使用join和left join来显示我的数据库。但看起来效果不太好。products.id,pdt.ProductName,dbpjs.CodeName,ordercustline.id as oid, pdt.LanguageID LEFTJOIN products ON products.id = ordercustline.ProductID
LEFT JOIN producttexts as pdt ON pdt.ProductID
我正在使用一个mySQL数据库中的5个表。系统是这样的,我有一个名为"owners“(客户)的顶层表,它具有本地业务(商店)。选择citation_sources.name,citation_shop.shop from citation_sources left join citation_shop on citation_sources.id= citation_shop.citation和citation_shop.shop in (6,7) left join shops on citation_shop