|
need to "join" another table with the one I have 12 Years, 2 Months ago
|
Karma: 0
|
|
this is my query and it works great,
SELECT
street_num,
street,
apt,
price,
beds,
baths,
sqft,
garage_size
FROM jos_iproperty
WHERE state=1
This is in an html Table Sorter... what I need is to attach or "join" another field from a secondary table within jos_iproperty.
It is "jos_iproperty_categories" and the field is "title".
This is a category distinction and it needs to be relative.
Thanks.
|
|
|
|
|
|
|
Re:need to "join" another table with the one I have 12 Years, 2 Months ago
|
Karma: 760
|
|
Hello,
What's relation between jos_iproperty and jos_iproperty_categories tables?
Regards,
ARI Soft
|
|
|
|
|
|
|
Re:need to "join" another table with the one I have 12 Years, 2 Months ago
|
Karma: 0
|
|
For each Property (as in Real Estate) the category is either Residential, Multi-Unit, or Manufactured. This is a table within the i_property table.
Does that answer the question??
|
|
|
|
|
|
|
Re:need to "join" another table with the one I have 12 Years, 2 Months ago
|
Karma: 760
|
|
No, what fields in the tables are used to link property and category.
Regards,
ARI Soft
|
|
|
|
|
|
|
Re:need to "join" another table with the one I have 12 Years, 2 Months ago
|
Karma: 0
|
|
As far as I can tell, it is the "id". I have looked at all the databases that are underneath the jos_property...
|
|
|
|
|
|
|
Re:need to "join" another table with the one I have 12 Years, 2 Months ago
|
Karma: 0
|
|
This is what I found,
There is a table within the jos_property named jos_property_propmid, in this, there are 2 fields, prop_id and cat_id. This seems to be the only place that there is any correlation. But, the original id field in the jos_property table is not called prop_id,...it is just "id". Although they seem to be the same.
|
|
|
|
|
|
|
