Hi,
I am looking to get the data from muliple tables.
Currently I am get Qualifier.select() and for each value init I get Process.id(),BondWire.id().
If i my SQL I can do it in call. (shown below). How can I accomplish the same ??


------------------------------------------
mysql>  select process.process , qualifier.id,bond_wire.type from process,bond_wire, qualifier where process.id=qualifier.process_id and bond_wire.id=qualifier.bondwire_id;
+---------+----+--------+
| process | id | type   |
+---------+----+--------+
| VIP11   | 1  | Copper |
| ABCD5   | 2  | Copper |
+---------+----+--------+
2 rows in set (0.00 sec)

I want to be able to do. How can I perform this?

My model simplified looks like this
----------------------------------------------------------
class Process(SQLObject):
    process = StringCol(length=50, alternateID=True)


class BondWire(SQLObject):
    type = StringCol(length=50, alternateID=True)

class Qualifier(SQLObject):
    qual = StringCol(length=3, notNull=True)
    process = ForeignKey('Process')
    bondwire = ForeignKey('BondWire')

-------------------------------------------

Thank you
Raju