Sorry das ich wieder nerve aber irgendwie will das nicht bring fehler....
2 Fehler:
SQL-command not properly ended
und
table or view does not exist
PHP:
SELECT prod_name FROM t_pdz_product_diff where prod_name='LYSRV-TI1SSD' INTO temp temp_p;
SELECT * FROM temp_p
UNION
SELECT prod_name,opt_name,opt_class
FROM t_must_opt
WHERE prod_name IN ( SELECT prod_name FROM temp_p)
and opt_class in('DEF', 'FIX');
DROP TABLE temp_p;
SQL-command not properly ended
und
table or view does not exist