MySQL JOIN заявка

[smoke]

Здравейте,

имам следния MYSQL код:

SELECT * FROM `imots` INNER JOIN `gradove`,`cvartal` ON (
	cvartal.id_grad = gradove.id;
	gradove.grad = imots.grad_id;
	cvartal.id = imots.cvartal_id;
)

изкарва ми грешка:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON ( cvartal.id_grad = gradove.id; gradove.grad = imots.grad_id; cvartal.i' at line 1

 

[alex3]

разделяй ги с , не с ;

 

[relax4o]

[sql]
SELECT *
FROM `imots` i, `gradove` g, `cvartal` c
WHERE c.id_grad = g.id AND g.grad = i.grad_id AND c.id = i.cvartal_id
[/sql]