ARI Soft - need to "join" another table with the one I have

Home

News

Forum

About Us

Demos

Products

F.A.Q.

Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

Show Cart

Recent Events

31/12/2023 New Year SALE

We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

more...
21/11/2023 BLACK FRIDAY 23 is coming

BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.

more...

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

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Data Tables

need to "join" another table with the one I have

(1 viewing) (1) Guest

Page: 12

TOPIC: need to "join" another table with the one I have

Forum Tools

#31501

Re:need to "join" another table with the one I have 11 Years, 10 Months ago	Karma: 748
What name of "id" column in jos_iproperty_categories table? Could you send SQL dump of "iproperty" tables by email? Regards, ARI Soft

admin

Last Edit: 2012/09/05 04:46 By admin.

The administrator has disabled public write access.

#31520

Re:need to "join" another table with the one I have 11 Years, 10 Months ago	Karma: 0
I have sent you 2 database dumps. First is just the tables that I thought were relative, and 2nd (in case I do not have a clue) is the full iproperty tables. Thanks for all your help.

mphillips

The administrator has disabled public write access.

#31521

Re:need to "join" another table with the one I have 11 Years, 10 Months ago Karma: 748

Use the following SQL query:

Code:



SELECT

  P.street_num,

  P.street,

  P.apt,

  P.price,

  P.beds,

  P.baths,

  P.sqft,

  P.garage_size,

  C.title AS Category

FROM 

  #__iproperty P LEFT JOIN #__iproperty_propmid PM

    ON P.id = PM.prop_id

  LEFT JOIN #__iproperty_categories C

    ON PM.cat_id = C.id

WHERE 

  P.state=1

GROUP BY

  P.id

Regards,
ARI Soft

admin

The administrator has disabled public write access.

#31533

Re:need to "join" another table with the one I have 11 Years, 10 Months ago	Karma: 0
Can you think of any reason that the categories data would show in some and not in others?? I have checked in the website and the information is there. I can see no difference between one or the other. By the way, Thank you for the quick responces

mphillips

The administrator has disabled public write access.

#31536

Re:need to "join" another table with the one I have 11 Years, 10 Months ago	Karma: 0
Okay, What I see happening is this. There are duplicate entry's for some property id's and any that are duplicated will not show the catagory. Have no idea if this is something that you can advise on?

mphillips

The administrator has disabled public write access.

#31544

Re:need to "join" another table with the one I have 11 Years, 10 Months ago	Karma: 748
Could you provide a screenshot with comments where we can see the problem? The SQL query shows only different properties on our side. Regards, ARI Soft

admin

The administrator has disabled public write access.

Page: 12

Useful Links