On Tue, Dec 20, 2011 at 8:11 AM, Mark Dexter <dextercow...@gmail.com> wrote: > You want to use the leftJoin() method of JDatabaseQuery. For example: > $query->leftJOIN('#__contact_details AS cd ON cd.user_id=u.id'); There > are a number of examples in the CMS. Good luck. Mark
> On Tue, Dec 20, 2011 at 1:36 AM, Soheil Novinfard <novinf...@gmail.com> > wrote: > > hi,
> > what is equal to Left Outer Join in joomla sql?
> > and if not how can I do? Do I have to built all my query in simple > > inline way?