Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How To Prevent Field Aliasing In SQL
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
How To Prevent Field Aliasing In SQL
Miscellaneous
Thread ID:
00938084
Message ID:
00938084
Views:
66
I have a custid field in 2 tables.

When I do;
SELECT TempLn.*, BSpotDt.*;
 FROM TempLn;
 JOIN BSpotDt ON TempLn.BoIdBase = BSpotDt.BoIdBase;
 WHERE &cSqlCmd2;
 INTO table Results
The custid then appears as custid_a and custid_b.

Any way to prevent this from happening?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Next
Reply
Map
View

Click here to load this message in the networking platform