MySQL Forums
Forum List  »  Russian

сложный запрос
Posted by: Max PK
Date: August 18, 2009 12:25AM

Запрос типа
select posnak.naimen, nakladna.namberchetf, sklad.cena
from posnak left join nakladna, sklad on posnak.idid = and posnak.naimen = sklad.naimen
на моем локальном компе (MySQL 3.23.0 up through 4.1.15.) работает без проблем.
А на хостинге (mysql-server-5.0.45-7.el5) выдает ошибку:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' sklad on posnak.idid = and posnak.naimen = sklad.naimen' at line 1

Помогите плиз изменить запрос чтоб работало.

Options: ReplyQuote

Written By
сложный запрос
August 18, 2009 12:25AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.