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

Select Model

HP Laserjet Series

HP Laserjet

Info	Qty   Buy	Product Code	Printer	OEM Code	Black/Colour	Price
		T LJ1010 OB	1005MFP, 1010,1012, 1015, 1018, 1020, 1022, 3015, 3020, 3030, 3050, 3052, 3055	Q2612A	Black	£ 31.99
		T LJ1320 HC	1160, 1320, 3390, 3392 (High Capacity)	Q5949A, Q5949X	Black	£ 65.00
		T LJ1200 LC	1000, 1200 Series	C7115A	Black	£ 35.25
		T LJ1200	1000, 1200 Series (High Capacity)	C7115X	Black	£ 41.13
		T LJ2300 OB	2300	Q2610A	Black	£ 60.00
		T LJ4000	4000, 5000 Series	C4127A	Black	£ 41.13
		T LJ4000HC	4000, 5000 Series	C4127X	Black	£ 52.88
		T LJ2100	2100, 2200 Series	C4096A	Black	£ 41.13
		T LJ5P	3100 Series	C3906A	Black	£ 35.00
		T LJ4	4, 4+, 4M, 4M+	92298A	Black	£ 35.00
		T LJ4L	4L, 4L+, 4P	92274A	Black	£ 41.13
		T LJ1100	1100 Series, 3200	C4092A	Black	£ 35.00
		T LJ5P	5P, 6P	C3903A	Black	£ 35.00
		T LJ5L	5L, 6L	C3906A	Black	£ 41.13
	No Stock	T LJ2P	II P, II P+, III	92275A	Black	£ 41.13
		T LJ5SI	8000	C3909A	Black	£ 50.00
	No Stock	T LJ2	II, II D, III, IIID	92295A	Black	£ 40.00
		T LJ5SI	5 Si	C3909A	Black	£ 50.00

Top