|  | Posted by dede on 08/18/07 00:05 
Hi guys..is there any query to do this action:
 i want to combine view record into a single record.
 exm.
 
 table 1
 Name      A      B
 Jack      10     22
 jack       12     21
 jack       ...      ....
 jack         1      11
 ben        12       2
 ben          3       2
 ben        ...       ...
 
 
 into:
 View 1
 Name                combine
 jack          10,22 and 12,21and1,11 and .....
 ben           12,2 and 3,2 and......
 
 
 thx before..
  Navigation: [Reply to this message] |