Warning: mysql_query(): Unable to save result set in /var/www/html/Connections/connCMS.php on line 14
Please contact your software provider.
Subquery returns more than 1 row
select p.*, pp.category, pc.cat_cat, pcl.c1_image, (SELECT file_name FROM product_files WHERE productnumber=p.productnumber AND file_type='Dimensional Drawing') as drawing from product p left join product_primaries pp on p.productnumber=pp.productnumber left join product_category pc on pc.catmatch=pp.category left join product_callouts pcl on pcl.productnumber=p.productnumber where p.productnumber ='AM501'