SELECT
	i.insid		'Instrument',
	c.insid		'Currency',
	pa.ptyid	'Market',
	p.*,

FROM
	instrument 	i,
	price 		p,
	party 		pa,
	instrument	c
WHERE
	i.insid=p.insid,
AND	p.ptynbr = pa.ptynbr
AND	c.insid = p.curr
AND 	p.day >= '2009-01-01'
AND 	p.day <= '2009-12-31'