Table from subquery

marymvlg28 · Post by **marymvlg28** » Tue Sep 23, 2014 11:12 pm

Hi :)

I would like to make a table that can be edited from a query containing both joins and subqueries.
The problem is that the msql views does not allow subqueries and I think either the custom views of PHPMaker.

I mean,
I have a sql table <transfers> that I need to edit and that works, but I need to add some data to show only.
This additional data that I need to show is in the same table <transfers> but under others conditions, that means I need to add a JOIN ( subquery ).

How can I do that with phpmaker?

danielc · Post by **danielc** » Wed Sep 24, 2014 1:13 pm

Create a view for your subquery and use that view instead of subquery.

Post schema of your tables, your SQL and explain what you want to edit.