Database query from email (using an article) template

[Revolution10]

Dear all,

I'm trying to create an email using the plugin and a template created form an article. I can use placeholders but I need to get some info from a related table. This table doesn't have a table join, this is linked using a join field. How can I place a query in this article to take this data?

thanks!

 

[Revolution10]

Finally editing the template