First let me state I am new to SQL so i presume this is going to be a user error vs. a problem with your product, which I love. I am trying to create a simple join where I join two columns from my product table and the price from my pricing table. This is what I am trying to use:

SELECT eif7g_hikashop_product.product_name, eif7g_hikashop_product.product_description, eif7g_hikashop_price.price_value
FROM
eif7g_hikashop_product
INNER JOIN eif7g_hikashop_price
ON eif7g_hikashop_product.product_id = eif7g_hikashop_price.product_id

Can one of your experts help this novice please.

Thanks.

Hello,

Could you send SQL dump of eif7g_hikashop_price and eif7g_hikashop_product tables by email so we can investigate the problem?

PS: SQL dump can be created in database tool like PHPMyAdmin which is usually available in hosting panel.

Regards,
ARI Soft

Just emailed you both files. Thanks.

Use the following SQL query:


SELECT
P.product_name,
P.product_description,
PR.price_value
FROM
#__hikashop_product P INNER JOIN #__hikashop_price PR
ON P.product_id = PR.price_product_id


Regards,
ARI Soft

Thanks. Is there someone I need a few more reports and willing to pay someone a few bucks to write me some good statements. Can you help?

You can contact us by email and describe what queries you need.

Regards,
ARI Soft