mc12345678 / EasyPopulate-4.0

Data import and export module for Zencart 1.3.x and 1.5.x
GNU General Public License v2.0
10 stars 8 forks source link

Add table alias for SELECT queries #54

Closed mc12345678 closed 4 years ago

mc12345678 commented 4 years ago

As identified in the forum: https://www.zen-cart.com/showthread.php?190417-EasyPopulate-4-0-Support-Thread&p=1369422#post1369422 using the generic sql for the primary_key requires the associated tables to include the table alias. The information captured to support primary key selection is based on using that field within select queries. Therefore tables that could potentially use that additional information need to be referenced using the anticipated table aliaas. To "simplify" the overall maintenance, all select queries have been revised to use a table alias even if the query is a simple query against a single table.

Fixes #53 for attribute basic imports.