Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 To: MD Dhanu
  
 
 
 MD Dhanu
 Tags
Subject: RE: VFP Error 1541 with sql command
Thread ID: 345284 Message ID: 345322 # Views: 45 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Tuesday, May 22, 2012 3:11:03 PM         
   


> Dear Expert,
>
> I have error 1541 when i using same table in one query.
>
>
> select a.*,b.nm_user as usernm,c.nm_user as replynm,
> LEFT(CONVERT(VARCHAR,a.posted, 120), 20) as posted
> from trx_jobhist a
> left outer join ms_users b on b.id_user=a.id_user
> left outer join ms_users c on c.id_user=a.replyto
> order by a.posted desc
>
>
> Any body know why it's happened ?
>
>
> thanks,
> MD Dhanu

Will it stop complaining if you use a1,b1, and c1 instead of a,b, and c?


Yuri Rubinov

ENTIRE THREAD

VFP Error 1541 with sql command Posted by MD Dhanu @ 5/22/2012 8:01:53 AM
RE: VFP Error 1541 with sql command Posted by Anders Altberg @ 5/22/2012 12:42:58 PM
RE: VFP Error 1541 with sql command Posted by Yuri Rubinov @ 5/22/2012 3:11:03 PM
RE: VFP Error 1541 with sql command Posted by MD Dhanu @ 5/23/2012 4:01:46 AM