Select distinct nhb_group_member.is_active, nhb_group_oup_id, nhb_group_member.has_mojo, A.group_owner, A.group_name, A.description, A.active_date, A.expire_date, A.is_public, B.group_name as 'group_owner_name' from nhb_group_member, nhb_group as A, nhb_group as B right join nhb_group on A.group_owner = B.group_id where A.group_id = nhb_group_oup_id and nhb_group_er_id = 'PER06262000.000000000001' In other server with version 5.0.11-beta-nt on Windows 2003 Server Standard works fine.īurk Price On Server version: "5.0.4-beta-Max / Ver 14.12 Distrib 5.0.13-rc, for unknown-linux-gnu (x86_64) using readline 5.0" I get the following as a result for this query: WHERE ts.id=p.id_tipus_sexe AND tv.id=p.id_tipus_via AND tu.id=id_tipus_usuari ![]() LEFT JOIN departaments d ON p.id_departament=d.id LEFT JOIN facultats f ON p.id_facultat=f.id SELECT f.facultat, p.TU, p.DNI, p.NIU, p.nom, p.cognom1, p.cognom2, ts.tipus as tipus_sexe,p.telefon, p.mobil, tv.abreviatura as tipus_via, p.direccio, p.codi_postal, p.poblacio, p.provincia, p.pais, p.email, date_format(p.data_naix,'%d/%m/%Y') as data_naix, p.curs, p.cicle, p.estudis, tu.tipus as tipus_usuari, d.departament, e1.esport as interes1, e2.esport as interes2, e3.esport as interes3, p.observacionsįROM participants p, tipus_usuari tu, tipus_via tv, tipus_sexe ts Lotusxxl I have the same problem with version 5.0.13 RC in Windows XP and Linux Ubuntu. The same query was working fine on 5.0.11-beta (on the same machine), and it's working very well with 4.1.13-log, in my production server (FreeBSD) Showing rows 0 - 29 (46 total, Query took 0.0041 sec) LEFT JOIN Products p2 ON p.ParentProductID = p2.ProductID When I try the same "left join" in a smaller query (with phpMyAdmin). Unknown column 'p.ParentProductID' in 'on clause' LEFT JOIN UserProducts up on up.DeniedProductID = p.ProductID and up.ConsultantID = 106577Īnd ifnull(cs.ConsultantID,ps.ConsultantID) = '106577' and DateContracted >= ' 0:0:00' and DateContracted <= ' 23:59:00' LEFT JOIN Users fup on fup.UserID = ps.ConsultantID LEFT JOIN Users fuc on fuc.UserID = cs.ConsultantID LEFT JOIN CommissionShare cs on pay.PaymentID = cs.PaymentID and cs.ConsultantID = '106577' LEFT JOIN Payments pay on ps.ProductSaleID = pay.ProductSaleID LEFT JOIN ProductStatuses pst on ps.StatusID = pst.ProductStatusID LEFT JOIN Products p2 on p.ParentProductID = p2.ProductID IFNULL(pst.ProductStatus,'Desconhecido') as ProductStatus, IF(p2.Name IS NULL, p.Name, concat(p2.Name,' - ', p.Name)) as ProductName, Ifnull(cs.ConsultantID,ps.ConsultantID) as CommissionConsultantID, I'm using Linux and I'm having the same kind of problem. #1054 - Unknown column 't1.type' in 'on clause' Left join t3 on t1.type = 'a' and t1.id = t3.t1_id #Test 2, swap the order of the conditions in "on" #1054 - Unknown column 't1.id' in 'on clause' Left join t3 on t1.id = t3.t1_id and t1.type = 'a' ![]() ![]() ![]() `id` int(10) unsigned NOT NULL auto_increment, LEFT JOIN gives the "#1054 - Unknown column 'xxxx' in 'on clause'" error on MySQL 5, but it's working fine in MySQL 4.1
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |