[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

[-Silver-]

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

Perfetto, grazie!