Hi Jarthel. More than likely there is more than one way to accomplish what you're asking, but for me the approach I typically take is to leverage one of Transfer's most beautiful features (to me, anyway): TQL
Using the Transfer Query Language, which you will find to be nearly identical to SQL, you can easily write your join queries and then have Transfer execute them for you! This is my preferred approach, anyway. Doug Boude On Thu, Jun 11, 2009 at 1:37 AM, 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 :) > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
