сложный запрос
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 = nakladna.id 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 = nakladna.id and posnak.naimen = sklad.naimen' at line 1
Помогите плиз изменить запрос чтоб работало.
Subject
Views
Written By
Posted
сложный запрос
6271
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.