Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Add to select
Message
From
18/11/2008 01:18:48
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01362260
Message ID:
01362485
Views:
8
thank you,it works
>>thank you for reply,
>>i see, but i need another empname from another table(Talias4.empdep),
>>
>>the field name it can be as empnamew
>>
>>
>See change inside. Does it solve your problem?
>
>
>
>SELECT;
> TAlias1.time1,;
> TAlias1.date1,;
> TAlias1.roomno,;
> TAlias1.place1,;
> TAlias2.mobile,;
> TAlias2.tel,;
> TAlias2.empname,;
> TAlias1.discerror,;
> TAlias1.sno,TAlias1.fexerno,talias3.des, TAlis4.EmpName as empnamew ;
> FROM trans1 as TAlias1 ;
> INNER JOIN emp1 as TAlias2 ;
> ON TAlias1.empno = TAlias2.empno ;
>INNER JOIN errtyp AS TAlias3 ; 
> ON TAlias1.proplemno=talias3.flag;
>INNER JOIN DepName AS TAlias4 ;
>ON Talias1.fexerno=Talias4.empno ;
> WHERE  TAlias1.fexerno>=0  AND TAlias1.mark1=0;
> ORDER BY TAlias1.date1,TAlias1.sno ;
> INTO CURSOR crsMyCursor READWRITE
Previous
Reply
Map
View

Click here to load this message in the networking platform