[MySQL]query su + tabelle

[piero.mac]

uniscili due volte....

SELECT pm.id, pm.titolo, pm.data, u1.user as da1, u2.user as per1
FROM pm
LEFT JOIN utenti u1 ON u1.id = pm.da
LEFT JOIN utenti u2 ON u2.id = pm.per
ORDER BY pm.data DESC
LIMIT 0 , 30