def _sel_func(self, cr, uid, context=None): obj = self.pool.get('stock.location') ids = obj.search(cr, uid, []) res = obj.read(cr, uid, ids, ['id','name'], context) res = [(r['id'],r['name']) for r in res] return res

Currently I'm using this code but what if two or more tables are needed to get the desired field. How can I do that using a sql query or any other approach?