DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]Lord_Jago[/eluser]
[quote author="Mareshal" date="1272826158"]I have this structure

Users: user_id, user_name, user_email, user_site
Article: article_id, article_title, article_link, user_id(FK.user_id -> Users)

Can I produce this query with DMZ?

Code:

SELECT a.*, u.user_name, u.user_email, u.user_site
FROM article AS a
LEFT JOIN users AS u
ON a.user_id = u.user_id
WHERE a.article_id = '{$art_id}'

[/quote]

It's possible with the include_related function. Something like :

Code:

$article = new Article();
$article->where('id', $art_id);
$article->include_related('user', array('username', 'email', 'site'));
$article->get();