ARI Soft - [SOLVED] Join two tables

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

23/11/2024 Black Friday 2024

BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

more...
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...

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

[SOLVED] Join two tables

(1 viewing) (1) Guest

Page: 12

TOPIC: [SOLVED] Join two tables

Forum Tools

#37972

Re:Join two tables 11 Years, 8 Months ago	Karma: 0
Thank you - sorry about that (turned on two many switches) The above works for a single join - what would I do for multiple joins from multiple tables? Tried this SELECT U.name, R.course_name, A.lpath_id, A.user_status, A.start_time FROM #__lms_learn_path_results A LEFT JOIN #__users U ON A.user_id = U.id A LEFT JOIN #__lms_courses R ON A.course_id = R.id

yws

Last Edit: 2013/03/06 05:31 By yws.

The administrator has disabled public write access.

#37979

Re:Join two tables 11 Years, 8 Months ago	Karma: 0
Fixed it A LEFT JOIN #__lms_courses R ON A.course_id = R.id should be LEFT JOIN #__lms_courses R ON A.course_id = R.id What is the first A for??

yws

The administrator has disabled public write access.

#37980

Re:Join two tables 11 Years, 8 Months ago	Karma: 760
You can read about JOIN syntax here. Regards, ARI Soft

admin

The administrator has disabled public write access.

Page: 12

Useful Links