SQL Syntax problems

Hi,

I'm trying to execute a join and am having trouble. Could you please have a look at the code and tell me where the problem is.

SELECT * from "FT-EMBA-Rankings"
join "names"
where 'FT-EMBA-Rankings.ID' = 'Names.ID';

Thanks.

Richard