[WEB400] Net.Data Variable names for join

["Peter Dow" <pcdow@xxxxxxxxx>]

Hi All,

I'm trying out Net.Data macros, and ran into the following problem.  Given a
function with something like

    SELECT * FROM GROUP as A JOIN PEOPLE as b ON a.PERSON1 = b.PERSON
                             JOIN PEOPLE as c ON a.PERSON2 = c.PERSON

how do you reference the fields?  Using $(NLIST), it appears that there is
no distinction, i.e. the "as a", "as b", and "as c" are ignored.  So if I
refer to variable $(V_b.PERSON) or $(V_c.PERSON), I get nothing.  If I refer
to $(V_PERSON), what should I expect to get?  The value from b.PERSON or
c.PERSON?

tia,
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com