Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: PhatMackn02
- Order by date
-
Max Timstamp / Effective Date
Hello, I am attempting to retrieve the most recent row or the most recent date in a query, I have used this custom SQL code and for some reason still retrieve a an extra row (Unique rows are not the matter): Ps_Stdnt_Fa_Term.Effdt = (SELECT MAX(C_Date.Effdt) FROM Ps_Stdnt_Fa_Term C_Date WHERE...- PhatMackn02
- Thread
- Replies: 0
- Forum: Data Management Tools general discussion
