StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow can I select from a derived table in Propel?
primarykey
Id
1069907
data
AcceptedAnswerId
1070033
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2009-07-01T15:43:43.410
FavoriteCount
0
LastActivityDate
2009-07-01T16:12:48.797
LastEditDate
LastEditorUserId
0
OwnerUserId
122017
ParentId
0
PostTypeId
1
Score
1
ViewCount
1106
LastEditorDisplayName
text
Body
I'm using v1.3 of the Propel PHP framework for an application, and I can't find a way to select from a derived table using the <code>Criteria</code> object. Part of the SQL I want is: <pre><code>SELECT unioned_table.foo, quux.stuff, baz.more_stuff... FROM quux INNER JOIN (SELECT foo, bar FROM table1 UNION SELECT foo, bar FROM table2 ) AS unioned_table ON quux.field = unioned_table.foo INNER JOIN baz ON baz.blah = unioned_table.bar INNER JOIN ... WHERE conditions... </code></pre> The actual SQL is more complex than this, but that just includes further joins. I've tried to use <code>Criteria::addAlias()</code>, though unfortunately that tries to SQL-escape the table definition. I eventually gave up on trying to write the SQL in that manner, and created a view (called <code>unisoned_table</code> in this example). I next tried to add joins to this table: <pre><code>$c->addSelectColumn('unioned_table.foo'); $c->addSelectColumn(QuuxPeer::STUFF); $c->addSelectColumn(BazPeer::MORE_STUFF); // ... $c->addJoin(QuuxPeer::FIELD, 'unioned_table.foo', Criteria::INNER_JOIN); $c->addJoin(BazPeer::BLAH, 'unioned_table.bar', Criteria::INNER_JOIN); // ... $c->add(QuuxPeer::STUFF, $someval); // ... </code></pre> Sadly this results in the view being joined twice -- once as an inner join with <code>qux</code>, and once as a cross join with <code>baz</code>. Bizarrely, if I remove the <code>baz</code> SELECT column, then the cross join disappears. Does anyone have any suggestions as to how I can do this? I can't use just bare custom SQL, as this <code>Criteria</code> may need to be modified (columns replaced, extra conditions added, etc) or used in a <code>doCount()</code> call.
Tags
<php><mysql><propel>
Title
How can I select from a derived table in Propel?
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USDMI
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POHow can I select from a derived table in Propel?
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.