|
midrange.com
This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Suppose we have folling data-table:
fld1 fld2 fld3
VES1 BEANT 13/05/2002
VES1 DEBRE 15/05/2002
VES1 DEHAM 16/05/2002
VES2 BEANT 15/05/2002
VES2 DEBRE 17/05/2002
VES2 DEHAM 18/05/2002
VES3 BEANT 17/05/2002
VES3 DEHAM 19/05/2002
Now we want following result, using SQL
VES1 VES2 VES3
BEANT 13/05/2002 15/05/2002 17/05/2002
DEBRE 15/05/2002 17/05/2002 ---
DEHAM 16/05/2002 18/05/2002 19/05/2002
Is this possible?
Patrick Goovaerts
ICT/Clipper Support nv
www.conti7.be
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
