ARI Soft - Grid from multiple tables in DB.

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 Smart Content

Grid from multiple tables in DB.

(1 viewing) (1) Guest

Page: 12

TOPIC: Grid from multiple tables in DB.

Forum Tools

#5995

Re:Grid from multiple tables in DB. 13 Years, 9 Months ago	Karma: 0
Hello all, Can someone post a sample on how to display fields from different tables using this component? Thank you

nemuelcruz

The administrator has disabled public write access.

#5996

Re:Grid from multiple tables in DB. 13 Years, 9 Months ago Karma: 748

If you want to display col1 and col2 from table 1 and col3 from table 3 and col4 is foreign key for these two tables, the following code can be used:

Code:



{arisqltable}

    {arisqltablequery}

SELECT T1.col1,T1.col2,T2.col3

FROM table1 T1,table2 T2

WHERE T1.col4=T2.col4

    {/arisqltablequery}

{/arisqltable}

If you provide structure of your tables, we can help create query for your needs.

Regards,
ARI Soft

admin