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?

Thanks

Hi Soheil,

As Mark points out JDatabaseQuery can handle this without any issues.  This
would be a great opportunity for someone to write up a tutorial chapter on
how to use JDatabaseQuery for our user manual.

https://github.com/joomla/joomla-platform/tree/staging/docs/manual/en...
http://developer.joomla.org/platform-manual.html

---
$query = $db->getQuery(true);

$query->select('table_one.field1, table_two.field2');
$query->from('table_one');
$query->leftJoin('table_two ON table_one.pk = table_two.fk');

OR you could be more explicit:

$query->join('LEFT OUTER', 'table_two ON table_one.pk = table_two.fk');