Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need SQL to find LATEST child record
Message
From
15/04/2003 16:19:06
John Cook
Bulletproof Software
Catawba, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Need SQL to find LATEST child record
Miscellaneous
Thread ID:
00777700
Message ID:
00778036
Views:
24
chad,
cstatus is NOT in the inmates table. It is ONLY in the acct_events table.
I could put it in the inmates table but that would be redundant data and it would get out of sync and you know the rest of that story.
John
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform