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]
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
-~----------~----~----~----~------~----~------~--~---
