Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
About SQL select command?
Message
From
09/03/1998 08:40:42
Mark Hall
Independent Developer & Voip Specialist
Keston, Kent, United Kingdom
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00083318
Message ID:
00083336
Views:
24
SELECT a.Member_Id, a.Name, a.email, b.Subject, b.Message ;
FROM TableA a, TableB b ;
WHERE a.member_id = b.Member_Id ;
ORDER BY 1, 4, 5

Note the use of column numbers to specify the order.

Regards
Mark
Regards
Mark

Microsoft VFP MCP
Menulib - OO Menus for VFP www.hidb.com/menulib
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform