Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: rajesh kudaravalli
  Where is rajesh kudaravalli?
 hyh
 India
 rajesh kudaravalli
 To: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 Tags
Subject: RE: split table
Thread ID: 248794 Message ID: 248969 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Saturday, December 26, 2009 7:32:48 AM         
   


> > 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


Dear Anders


I run your query in visual foxpro 6.0 but i got an error that is "alias t1 is not found".

Please rectify my problem. i am new to visual foxpro so clear my doubt what is t1.


if it is posible to write a program for it.please give me program.

thanks and regards

kudaravalli

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