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 -~----------~----~----~----~------~----~------~--~---
