Thanks in advance to any help which to some is probably simple.. to me .. horrifying.
I have an asp page that queries a database and gets all the Title, ItemID, and Expiration Fields where a username is true. (I alreadyhave the SQL for this)
BUT... now that I have that info,I can not figure...
I have a field called MemberName(text) and a field called goldsmithing(number)
I want to display the MEMBERNAME who has the highest goldsmithing rate.
I have:
SQL = "Select * from Members Where Goldsmithing = MAX(Goldsmithing)"
Its giving me an aggrogate function error. Can someone please...
OK I think I could get the second one to work... but because Im new and I want to learn all I can will you please show me how the embedded SQL statement would look?
THanks for the quick response I appreciate it.
Sorry guys... Newbie here... I could really use some help.
I have a proejct where I want to compare 2 MSSQL tables and update only one of them.
Example: I have..
tblCancel with fields cancel_username and cancel_datetime (With this format 7/7/2004 4:38:25 PM)
and
tblUsers with fields...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.