Hi All,
I have a .DBF which has 4 fields. They are: "ID", "HGROUP", "LEVEL", "EMAIL". What I would like to get is the "email" by finding the lowest of the "LEVEL", then "ID" for a particular "HGROUP". Here is an extract of .DBF values:
ID HGROUP LEVEL EMAIL
237 44 2 abc123@123.com
238 44 1 mike@try.ca
239 44 1 joey@st.ca
241 44 3 helloworld@niceone.com
So, if I enter '44' as an input, I would need to get a result as "mike@try.ca"
Any help on getting this with a SELECT or something?
Thanks,
FOXUP!
I have a .DBF which has 4 fields. They are: "ID", "HGROUP", "LEVEL", "EMAIL". What I would like to get is the "email" by finding the lowest of the "LEVEL", then "ID" for a particular "HGROUP". Here is an extract of .DBF values:
ID HGROUP LEVEL EMAIL
237 44 2 abc123@123.com
238 44 1 mike@try.ca
239 44 1 joey@st.ca
241 44 3 helloworld@niceone.com
So, if I enter '44' as an input, I would need to get a result as "mike@try.ca"
Any help on getting this with a SELECT or something?
Thanks,
FOXUP!