SELECT passwd.id AS id, ownerid, login, lastlogin, expdate, domains.name AS domain, TYPE , quota_www, quota_sh, quota_mail, quota_ftp, CONCAT( customers.lastname, ' ', customers.name ) AS customername
FROM passwd
LEFT JOIN customers ON customers.id = ownerid LEFT JOIN domains ON domains.id = domainid WHERE 1 =1 ORDER BY login ASC , customername LIMIT 0 , 30
*MySQL zwrócił komunikat:*
| #1052 - Kolumna: 'ownerid' w field list jest dwuznaczna
--- |Napotkano błędy w bazie danych! *Zapytanie:* SELECT passwd.id AS id, ownerid, login, lastlogin, expdate, domains.name AS domain, type, quota_www, quota_sh, quota_mail, quota_ftp, CONCAT(customers.lastname, ' ', customers.name) AS customername FROM passwd LEFT JOIN customers ON customers.id = ownerid LEFT JOIN domains ON domains.id = domainid WHERE 1=1 ORDER BY login asc, customername *Błąd:* Kolumna: 'ownerid' w field list jest dwuznaczna ---
Jak to naprawić?
_______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms