http://docs.transfer-orm.com/wiki/Transfer_Query_Language.cfm#Auto_Joins
Mark On Thu, Jun 11, 2009 at 4:37 PM, jarthel <[email protected]> wrote: > > Is it possible to use transfer.get to retrieve fields from multiple > table? > > something along the lines of: > > select a.project_id, b.client_id, b.client_name, a.project_manager > from projects a, clients b where a.client_id = b.client_id and > a.project_id = xxx > > I see happening in almost every program I've done. > > If not possible, what is the workaround? The only workaround I can > think of is doing the select twice. Something like: > select * from projects where project_id = xxx; > select * from clients where client_id = client_id_from_sql_above > > Thank you for the help :) > > > > -- E: [email protected] W: www.compoundtheory.com --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
