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

Select Model

Canon LBP Series

Canon LBP

Info	Qty   Buy	Product Code	Printer	OEM Code	Black/Colour	Price
	No Stock	T LJ2P	4, 4+, 4 Lite, 4 Mark	92275A	Black	£ 41.13
		T LJ4L	4i, 4U	92274A	Black	£ 41.13
	No Stock	T LJ2	8, 8II, 8III, 8III+	92295A	Black	£ 40.00
		T LJ4	8IV	92298A	Black	£ 35.00
		T LJ4L	430	92274A	Black	£ 41.13
		T LJ5L	460, 465	C3906A	Black	£ 41.13
		T LJ5L	660	C3906A	Black	£ 41.13
	No Stock	T LJ2	840		Black	£ 40.00
		T LJ4	860		Black	£ 35.00
		T LJ4	EX		Black	£ 35.00
	No Stock	T LJ2P	LX		Black	£ 41.13
	No Stock	T LJ2	RX, SX, TX		Black	£ 40.00
		T LJ4	1260		Black	£ 35.00

Top