Please post your question on the user mailing-list.
Thanks,
Fabien
Charles Hilditch wrote:
> I couldn't find an active phpdoctrine mailing list to ask this question...
> How would I achieve this simple cross join in doctrine?
>
> SELECT p.propertyid, s.suburb FROM properties p, suburbs s WHERE
> p.suburbId = s.suburbId
> ...or...
> SELECT p.propertyid, s.suburb FROM properties p CROSS JOIN suburbs s ON
> p.suburbId = s.suburbId
>
> // I thought the syntax may go something like:
> $result = $q->
> select(' p.propertyId, s.suburb')->
> from('AroProperties p, AroSuburbs s')->
> where('p.suburbId = s.suburbId')->
> execute(array(), Doctrine::FETCH_ARRAY);
>
> Thanks!
>
> --
> Charles Hilditch
> Web Developer
> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
> http://www.crh-systems.com/
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-devs?hl=en
-~----------~----~----~----~------~----~------~--~---
