Originariamente inviato da bugme.it
codice:
SELECT article. * , container.title AS cont, utenti.username
FROM (
(
article INNER JOIN container ON article.cont_id = container.id
)
INNER JOIN article ON article.user_id = utenti.id
)
ORDER BY article.data_ins DESC
Però mi da errore:
#1066 - Not unique table/alias: 'article'

Che stupido...

codice:
SELECT article. * , container.title AS cont, utenti.username
FROM (
(
article INNER JOIN container ON article.cont_id = container.id
)
INNER JOIN utenti ON article.user_id = utenti.id
)
ORDER BY article.data_ins DESC