[eluser]mandrake[/eluser]
[quote author="OverZealous" date="1258075125"][quote author="mandrake" date="1258065242"]It's possible generate with Datamapper a query like this:[/quote]
Was that a question? ;-)
...
But you didn't provide enough information. How are image and table related (1-to-N or 1-to-1)? If they are 1-to-1, you can include the columns from images in your results. If they are 1-to-N, there is no way in DMZ, currently, to include the columns. You'll have to run an extra query for each result to get those columns.
The next version of DMZ (yet to be released) will have support for subqueries, which could be used for this. You still won't be able to write compound JOIN statements, and I don't have any plans to include them.
...
[/quote]
Yes, it was a question.
Sorry for my English. :-(
The relation is 1-to-n.
Reading the documentation I had 'almost' understood that you could not do.
I just wanted a confirmation.