DBAPI: Do a join select

835 Posts

aour Reply #1, 20 years, 11 months ago

Hi

Is it possible with the DBAPI to performing a join request :

exemple :

SELECT t1.name, t2.salary FROM employee t1, info t2 WHERE t1.name = t2.name;

Aour

Aour

[img]http://modxcms.com/assets/images/promo/modx-most-promising-open-source-winner.gif[/img]
[font=Verdana]Recherche | Support Francophone |Demander de l'aide | Documentation FR | Rapporter un Bug | [url=http://modxcms.com/forums/index.php/topic,2533.0.html][b]R

1,732 Posts

xwisdom Reply #2, 20 years, 11 months ago

Sure you can:

$ds = $modx->db->query("SELECT t1.name, t2.salary FROM employee t1, info t2 WHERE t1.name = t2.name;");

xWisdom
www.xwisdomhtml.com
The fear of the Lord is the beginning of wisdom:
MODx Co-Founder - Create and do more with less.

835 Posts

aour Reply #3, 20 years, 11 months ago

Sorry for this question, I’m confused embarrassed

I only read the Select DBAPI

http://modxcms.com/dbapi-select.html

Aour

Aour

[img]http://modxcms.com/assets/images/promo/modx-most-promising-open-source-winner.gif[/img]
[font=Verdana]Recherche | Support Francophone |Demander de l'aide | Documentation FR | Rapporter un Bug | [url=http://modxcms.com/forums/index.php/topic,2533.0.html][b]R

☆ A M B ☆
24,524 Posts

sottwell Reply #4, 20 years, 11 months ago

Most of the APIs are for basic queries, probably 90% of what is used. For the rest, the more complex queries, the $modx->db->query() function is needed.

Studying MODX in the desert - http://sottwell.com
Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
Join the Slack Community - http://modx.org