select distinct cartridges.model, displayorder.position from cartridges inner join displayorder on cartridges.model = displayorder.productgroup where cartridges.manufacturer = 'Canon' and cartridges.printertype = 'oem' and displayorder.producttype = 'oem' order by displayorder.position

Select Model

Canon Pixma IP Series

Canon OEM Series

Canon Pixma IP

Info	Qty   Buy	Product Code	Printer	Black/Colour	Price
		C CLI-8Bk OEM	3300, 4200, 4300, 5200, 5300, 6600D, 6700D	Black	£ 10.56
		C CLI-8C	3300, 4200, 4300, 5200, 5300, 6600D, 6700D	Cyan	£ 10.55
		C CLI-8M OEM	3300, 4200, 4300, 5200, 5300, 6600D, 6700D	Magenta	£ 10.55
		C CLI-8Y OEM	3300, 4200, 4300, 5200, 5300, 6600D, 6700D	Yellow	£ 10.55

Top

Canon OEM

Info	Qty   Buy	Product Code	OEM Code	Black/Colour	Price
	No Stock	CAN BC-02	BC-02	Black	£ 20.00
	No Stock	CAN BC-05	BC-05	Colour	£ 24.00
	No Stock	CAN BC-20	BC-20	Black	£ 26.00
	No Stock	CAN BX-3	BX-3	Black	£ 18.00

Top