Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How will i use Alias in SQL Statement
Message
From
21/05/2005 03:15:07
Holden Barbadillo
E-Fildan
Davao, Philippines
 
 
To
21/05/2005 03:01:46
Abdulla Abdul Rahiman
Alits Information Technology
Dubai, United Arab Emirates
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: How will i use Alias in SQL Statement
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01016437
Message ID:
01016438
Views:
28
Try this one:

cSql = "Select EmpMst.EmpName As Name,EmpAtt.EmpDate As Date,EmpAtt.EmpAtt As AttHrs,EmpAtt.EmpRate As ;
Rate From BetaSql.dbo.EmpMst a,BetaSql.dbo.EmpAtt b where Len(aEmpCode) > 0 and a.Empcode = ?;
cEmpCode And a.EmpCode = b.EmpCode"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform