... related to my ID: 27314902
Dear EE Experts,
We would like to ask for tech support on how to add table_name from FROM part in SQL Query.
From the SQL Query that we got from EE expert (carrzkiss), here's the query that was advised:
>>sqlContent.commandtext = "SELECT category.categoryid, category.categoryname, category.pathcate, category.groupid, series.seriesid, series.typeid, series.brandid, series.series_name FROM category INNER JOIN series ON category.categoryid = series.categoryid WHERE series.seriesid=?"<<
The FROM have the Category table, and INNER JOIN series table, in whereas the column name "image1" & "product_name" can't be found in Category & Series table, but can be found in Products table.
Kindly see the attached images, specially the web error for the error result that we received, even we set an seriesID for it...
Thank you & hope to hear soon...