hey i think that i found the problem..

it isn't the query as syntax... but the fields type.. i don't have result in that query cause the fields perioxi, address are int(11), not null with 0...

SELECT
a.cords as acords,
a.title_greek as addressname,
p.cords as pcords,
p.title_greek as perioxiname,
l.title_greek as locationname
FROM
cg_business
INNER JOIN location_details a ON...

Ok now with your example above.. i can clearly ask you if what i want can be done.

The table that links the other in your example
-----------
| model_id |
-----------
|
model_id.id

hello everyone.. i'm a newby in mysql but i'm trying hard.

So i won't lose a minute, and i'll go straight into the heart of the problem.

I have the following mysql dumps:

DROP TABLE IF...