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

Select Model

Apple Laserwriter Series

Apple Personal Laserwriter Series

Apple Laserwriter

Info	Qty   Buy	Product Code	Printer	OEM Code	Black/Colour	Price
	No Stock	T LJ2	II Series		Black	£ 40.00
		T LJ4	Pro 600 Serie		Black	£ 35.00
		T LJ4	Select 1600 S		Black	£ 35.00

Top

Apple Personal Laserwriter

Info	Qty   Buy	Product Code	Printer	OEM Code	Black/Colour	Price
		T LJ4L	300		Black	£ 41.13
	No Stock	T LJ2P	4, L		Black	£ 41.13

Top