Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to structure a SQL Select command
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01180237
Message ID:
01180267
Views:
11
Thanks, Naomi. I'll check it out . . .



>Try this - not tested
>
>Select * from Arts inner join Tasks on Arts.ArtID = Tasks.ArtID ;
>where Task.ArtID+dtos(Task.Task_Date) in ;
>(select Task.ArtID+dtos(Task.Task_Date) as TaskDate from Tasks ;
>group by ArtID order by Task_Date descending where Task = lcSpecific_Task)
eCost.com continues to rip people off
Check their rating at ResellerRatings.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform