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

Select Model

Sharp AJ Series

Sharp AJ

Info	Qty   Buy	Product Code	Printer	Black/Colour	Price
		CS AJT20B	1800, 1805, 2000, 2100, 2200, 6000, 6010, 6020, 6110	Black	£ 9.00
		CS AJT20C	1800, 1805, 2000, 2100, 2200, 6000, 6010, 6020, 6110	Cyan	£ 5.00
		CS AJT20M	1800, 1805, 2000, 2100, 2200, 6000, 6010, 6020, 6110	Magenta	£ 5.00
		CS AJT20Y	1800, 1805, 2000, 2100, 2200, 6000, 6010, 6020, 6110	Yellow	£ 5.00

Top

Ink Refills Kits are available for Black, Colour and Photo Cartridges