22-08-2011, 16:02
Dzieki za pomoc, udalo mi sie takim zapytaniem:
Kod:
SELECT k.kat_id as kat_id, k.kat_nazwa as kat_nazwa, DATE_FORMAT(k.kat_wdate,'%d/%m/%Y %H:%i') as kat_wdate, DATE_FORMAT(k.kat_mdate,'%d/%m/%Y %H:%i') as kat_mdate, u.login as login1, ua.login as login2
FROM kategorie k LEFT JOIN users u
ON k.id = u.id LEFT JOIN users ua
ON k.idm = ua.id;