I am trying to get an sql query that will do the following:
Give me a list of users that would include
FirstName, LastName, DisplayName, Email and a "custom" field I put in that is a date that their license from the state expires.
From looking at the database here is what I can determine.
FirstName, LastName, DisplayName, Email is from the Users table
The "expiration date" is the "PropertyValue" for "PropertyDefinitionID" '78" from the UserProfile table
Only thing is I am clueless on how to write the query.
Can anyone help?
Thanks in advance,
Mike