Stephen Russell wrote: > On Tue, Jan 20, 2009 at 10:44 AM, Ricardo Aráoz <ricar...@gmail.com> wrote: > >> Hi all, >> had an unusual requirement regarding some sql statements and I >> wanted to share what I've learned with the list, it might be useful to >> someone. >> >> We have 3 tables, say T1, T2, T3. >> T1 has a one to many relationship to T2 and to T3. >> The customer wants to list the tables as follows. >> >> Say a record in T1 can be linked to 2 records in T2 and 5 records in T3. >> Then he would want : >> (record #s in parenthesis)(Fn = Field # n) >> >> T1.F1(1) T1.F2(1) T1.F3(1) T1.F4(1) T2.F1(1) T2.F2(1) >> T2F3(1) T3.F1(1) T3.F2(1) T3.F3(1) >> T1.F1(1) T1.F2(1) T2.F1(2) >> T2.F2(2) T2F3(2) T3.F1(2) T3.F2(2) T3.F3(2) >> T1.F1(1) T1.F2(1) >> > -------------------------------------------------------- > > If you had used XML we would understand this outcome. > > Bad Steve! > > I am so lost with this description, what I see above is it 3 rows, > using T1.F1(1) as the primary indicator ? > > It looked good to see all that SQL code. > > Are you doing that in VFP or running a SP to crank that out? > Forgot to tell you, I don't like SP's, so no, no SP's just queries.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/49767469.1020...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.