我想使用join和left join来显示我的数据库。但看起来效果不太好。pdt.ProductName,dbpjs.CodeName,ordercustline.id as oid, pdt.LanguageID LEFT JOINproducts ON products.id = ordercustline.ProductID
LEFT JOIN producttexts as pdt ON pdt.ProductID= products.id
invoice_hearing_aids t2 WHERE t2.contact_id = invoice_hearing_aids.contact_id) ) sel
LEFT JOIN hearing_aid_makes makes ON makes.id= sel.make_id
LEFT JOIN contacts ON contacts.id = sel.
INSERT INTO views T ON '$username' = T2.username
(ITEM_ID, ITEM_TYPE, USER_ID错误:您的SQL语法中有一个错误;请查看与您的MySQL服务器版本对应的手册,了解要在'testuser‘= T2上使用near 'T JOIN members T2的正确语法。
我的MySQL数据库中有以下表:id INT NOT NULL AUTO_INCREMENT,Title VARCHAR我正在尝试用JOIN实现第二部分,但是我的语法有问题:SELECT film_id FROM Films_GenresWHERE genre_id IN SELECT id FROM Genres WHERE Name = '$genre'))
<e