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

Select Model

Samsung ML Series

Samsung ML

Info	Qty   Buy	Product Code	Printer	OEM Code	Black/Colour	Price
	No Stock	T ML1210	1010, 1020		Black	£ 30.00
	No Stock	T ML1210	1210, 1220, 1250		Black	£ 30.00
	No Stock	T ML1210	1430		Black	£ 30.00

Top