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

Select Model

OKI # Series

OKI OL Series

OKI OF Series

OKI #

Info	Qty   Buy	Product Code	Printer	OEM Code	Black/Colour	Price
		T OKI400	400		Black	£ 21.14
		T OKI400E	400e, 400w		Black	£ 18.50

Top

OKI OL

Info	Qty   Buy	Product Code	Printer	OEM Code	Black/Colour	Price
		T OKI400E	400ex		Black	£ 18.50
		T OKI400	410		Black	£ 21.14
		T OKI400E	410e, 410ex		Black	£ 18.50
		T OKI400E	600, 610		Black	£ 18.50
		T OKI400	800, 810		Black	£ 21.14
		T OKI400E	810ex		Black	£ 18.50
		T OKI400	820, 830, 830+, 840, 8		Black	£ 21.14

Top

OKI OF

Info	Qty   Buy	Product Code	Printer	OEM Code	Black/Colour	Price
		T OKI400	110,150		Black	£ 21.14
		T OKI400E	1000, 1050		Black	£ 18.50
		T OKI400E	2200, 2300, 2350, 2400		Black	£ 18.50
		T OKI400E	5200, 5500		Black	£ 18.50

Top