Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 18/11/2017 Black Friday is coming

    Don't wait BLACK FRIDAY, use FRIDAY17 coupon code to get 35% discount for all our extensions right now.

  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

INNER Join not working
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: INNER Join not working
#42388
INNER Join not working 4 Years, 5 Months ago Karma: 0
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.
The administrator has disabled public write access.
 
#42392
Re:INNER Join not working 4 Years, 5 Months ago Karma: 670
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
The administrator has disabled public write access.
 
#42400
Re:INNER Join not working 4 Years, 5 Months ago Karma: 0
Just emailed you both files. Thanks.
The administrator has disabled public write access.
 
#42401
Re:INNER Join not working 4 Years, 5 Months ago Karma: 670
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
The administrator has disabled public write access.
 
#42407
Re:INNER Join not working 4 Years, 5 Months ago Karma: 0
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?
The administrator has disabled public write access.
 
#42420
Re:INNER Join not working 4 Years, 5 Months ago Karma: 670
You can contact us by email and describe what queries you need.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 1