SELECT
	t.trdnbr,
	i.insid,
	c.insid,
	t.*,
	i.*
FROM
	trade t,
	instrument i,
	instrument c
WHERE
	t.insaddr = i.insaddr
AND	c.insaddr = i.curr