Help with inner join query

[dbrewerton]

I know I'm missing something below but my eyes are failing to see it. Between these two tables, the common element is contact_id. Can someone lend me a hand please? Thank you

SELECT ewise_device.device_id,ewise_device.contact_id,egw_addressbook.n_fn,
egw_addressbook.adr_one_locality,egw_addressbook.adr_one_region, 
ewise_device.device_postalcode FROM ewise_device,egw_addressbook
INNER JOIN ewise_device.contact_id on 
(ewise_device.contact_id = egw_addressbook.contact_id) 
WHERE contact_id IS NOT NULL

[mwasif]

[CODE=mysql]SELECT ewise_device.de vice_id,ewise_d evice.contact_i d,egw_addressbo ok.n_fn,
egw_addressbook .adr_one_locali ty,egw_addressb ook.adr_one_reg ion,
ewise_device.de vice_postalcode FROM ewise_device
INNER JOIN egw_addressbook on
ewise_device.co ntact_id = egw_addressbook .contact_id)
WHERE contact_id IS NOT NULL[/CODE]

[dbrewerton]

Many Thanks :) I really appreciate your help :)