Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: rajesh kudaravalli
  Where is rajesh kudaravalli?
 hyh
 India
 rajesh kudaravalli
 Tags
Subject: RE: split table
Thread ID: 248794 Message ID: 248796 # Views: 1 # Ratings: 3
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Wednesday, December 23, 2009 12:38:09 PM         
   


> dear all
>
> i have a table like below manner
>
> sno
> -------
> 1
> 2
> 3
> ....
> 10
>
> now i want to copy data like another table
>
> sno1 sno2
>
> 1 6
> 2 7
> 3 8
> 4 9
> 5 10
>
>
> please help me
>
> thanks and regards
>
> kudaravalli

SELECT T1.sno as sno1 , T2.sno AS sno2 ;
 FROM mytable T1 JOIN Mytable AS T2 ;
 ON T2.sno=T1.sno + 5 ;
 WHERE T1.sno <=5 
 INTO CURSOR Q1 


-Anders

ENTIRE THREAD

split table Posted by rajesh kudaravalli @ 12/23/2009 12:24:22 PM
RE: split table Posted by Anders Altberg @ 12/23/2009 12:38:09 PM
RE: split table Posted by rajesh kudaravalli @ 12/26/2009 7:32:48 AM
RE: split table Posted by Anders Altberg @ 12/26/2009 12:25:34 PM
RE: split table Posted by Anders Altberg @ 12/23/2009 1:08:06 PM
RE: split table Posted by M. Akram Bhatti @ 12/26/2009 7:50:14 AM