Firstly, the syntax you are using is quite old. You should be specifying joins in the from clause (unless you DB doesn't support it).
Outer joins aren't created by the framework as all of the retrieve criteria and multiretrieve criteria work on object to object relationships, and there is an assumption that empty objects aren't persisted or retrievable.
That said, you can do what you want using CPersistenceBroker.ProcessDirectSQL()
Simply pass the SQL string as you have posted and the framework will convert the class and property names into tables and columns based on your mappings. The result will be a CCursor object that you can use to access the recordset.
Note: I am assuming that item and reward are class names not table names.
- Richard.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I want to build this query
select item.id,item.name,item.price,reward.discount from item ,reward where item.itemid*=reward.itemid
Firstly, the syntax you are using is quite old. You should be specifying joins in the from clause (unless you DB doesn't support it).
Outer joins aren't created by the framework as all of the retrieve criteria and multiretrieve criteria work on object to object relationships, and there is an assumption that empty objects aren't persisted or retrievable.
That said, you can do what you want using CPersistenceBroker.ProcessDirectSQL()
Simply pass the SQL string as you have posted and the framework will convert the class and property names into tables and columns based on your mappings. The result will be a CCursor object that you can use to access the recordset.
Note: I am assuming that item and reward are class names not table names.
- Richard.