also please don't double post, simple things like this could be answer in the TG mailing list.

the unspoken rule is if your running SO on top of TG email there if noone knows forward it here. and of course search the archives/google before asking :)

On 1/26/07, Raju Subban <rajusubbanna@gmail.com> wrote:
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

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to turbogears@googlegroups.com
To unsubscribe from this group, send email to turbogears-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---