Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: MD Dhanu
  
 
 
 MD Dhanu
 Tags
Subject: VFP Error 1541 with sql command
Thread ID: 345284 Message ID: 345284 # Views: 63 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Tuesday, May 22, 2012 8:01:53 AM         
   


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

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