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: 248995 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Saturday, December 26, 2009 12:25:34 PM         
   


> >
> >
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".
> the
> 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

Paste my code into your program. Verify that T1 has NOT been omitted in the clause FROM Mytable T1, which can also be written FROM Mytable AS T1 (where you have replaced "Mytable" with your real tablename.)

You may also want to change JOIN to LEFT JOIN for the case where there's a gap in numbering.
-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