You need to specify the name that you want to display in your query so for example if you had two database tables one containing manufacturers and the other containing models linked by a foreign key in the models table the pseudo code would look like this:
SELECT manufacturersName, modelName, etc, etc
FROM tbl_manufacturers
INNER JOIN tbl_models ON (tbl_manufacturers.id = tbl_models.foreignkey)
Does that help.