Hi Kevin!
>Is there a way, in VFP8, that you can generate XML which combines 2 aliases, and vice-versa?
>
>I have some XML being returned from a method, but I can't get all the info I need into 1 select because there is a one-to-many relationship with another table.
>
>In a nutshell, I need to try and get all my info across in one method call.
You can generate first one cursor with all your info (see
left join in Select statement). After, you can generate a XML with this cursor. For this use CursorToXML() function.
Bye!
Erick
Força Sempre!
Strength Always!