Database error: Invalid SQL: CREATE TABLE testtable TYPE=HEAP SELECT distinct kits.PARTNO as mycount from kits, printers, items_detail where kits.OEM_Cartridge=printers.OEM_Cartridge and printers.OEM_Brand=NULL and printers.OEM_Brand=kits.OEM_Brand and kits.PARTNO=items_detail.PARTNO and items_detail.AVAILABLE='0' and kits.PARTNO <> NULL group by items_detail.PARTNO
MySQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=HEAP SELECT distinct kits.PARTNO as mycount from kits, printers, items_deta' at line 1)
Session halted.