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

Select Model

Brother HL Series

Brother HLP Series

Brother FAX Series

Brother MFC Series

Brother HL

Info	Qty   Buy	Product Code	Printer	OEM Code	Black/Colour	Price
	No Stock	T LJ2P	4, 6 Series		Black	£ 41.13
	No Stock	T LJ2	8 Series (except HL-8		Black	£ 40.00
	No Stock	T LJ4V	8 PSJ		Black	£ 58.75
	No Stock	T LJ2	10 Series		Black	£ 40.00
		T TN100	630, 631, 660		Black	£ 11.07
		T TN200	720, 730, 760		Black	£ 10.92
		T TN300	820		Black	£ 14.15
		T LJ4	960		Black	£ 35.00
		T TN300	1020, 1040, 1050, 1060		Black	£ 14.15
		T TN6600	1030		Black	£ 40.00
		T TN6600	1230, 1240, 1250,1270		Black	£ 40.00
		T LJ4	1260		Black	£ 35.00
		T TN6600	1440, 1450, 1470		Black	£ 40.00
		T LJ4	1660		Black	£ 35.00
		T TN6600	8350, L7		Black	£ 40.00
		T TN300	P2000		Black	£ 14.15
		T TN6600	P2500		Black	£ 40.00
		T TN7600	1650, 1670		Black	£ 42.59
		T TN7600	1850, 1870		Black	£ 42.59
		T TN7600	5040, 5050		Black	£ 42.59

Top

Brother HLP

Info	Qty   Buy	Product Code	Printer	OEM Code	Black/Colour	Price
		T TN6600	2500		Black	£ 40.00

Top

Brother FAX

Info	Qty   Buy	Product Code	Printer	OEM Code	Black/Colour	Price
		T TN100	500P		Black	£ 11.07
		T TN200	8000, 8060, 8200, 8250, 8650		Black	£ 10.92
		T TN6600	4750, 5750, 8350P, 8360P, 8750P		Black	£ 40.00

Top

Brother MFC

Info	Qty   Buy	Product Code	Printer	OEM Code	Black/Colour	Price
		T TN100	600		Black	£ 11.07
		T TN6600	8300J, 8500J, 8600		Black	£ 40.00
		T TN200	9000, 9050, 9060, 9550		Black	£ 10.92
		T TN6600	9600, 9600J, 9650, 9660, 9750		Black	£ 40.00
		T TN6600	9760, 9850, 9860, 9870, 9880		Black	£ 40.00

Top