Насколько я поняла вопрос в простейшем случае:
CREATE TABLE `tm_price` (
`nID` int(11) NOT NULL auto_increment,
`nPrice` float(11,2) NOT NULL default '0.00',
PRIMARY KEY (`nID`)
) TYPE=MyISAM
CREATE TABLE `tm_article` (
`nID` int(11) NOT NULL auto_increment,
`nPriceID` int(11) default NULL,
`strArticle` varchar(50) NOT NULL default '',
`strInfo` text,
`strUnit` varchar(10) NOT NULL default '',
PRIMARY KEY (`nID`)
) TYPE=MyISAM

select tm_price.nID,strArticle,strInfo,strUnit
from tm_price,tm_article
where tm_price.nID=tm_article.nPriceID
order by tm_price.nID