[SQL] Problema niubbo con una SELECT che fa join di 2 tabelle

[br1]

se non ricordo male...

SELECT
main.id,
files1.file_content as content1,
files2.file_content as content2
FROM
main,
files as files1,
files as files2
WHERE
files1.id_file = main.id_file1 AND
files2.id_file = main.id_file2