Re: Using two tables with DATEDIFF

[Peter Brawley]

From table1, not table1 from.

Don't quote the Selects, put them in parens.

Or write ...

select datediff(a.date_finish,b.date_start)
from table1 a
join table2 b using(id)
where a.id='xxx';