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 <> wrote:
I am looking to get the data from muliple tables.
Currently I am get and for each value init I get,
If i my SQL I can do it in call. (shown below). How can I accomplish the same ??

mysql>  select process.process ,,bond_wire.type from process,bond_wire, qualifier where and;
| 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

You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to
To unsubscribe from this group, send email to
For more options, visit this group at