If you look at the example in the updated UDF for WMIQUERY() in the UDF section, Rad provides a good example of trying to find all of the memory sticks. Just use the same methodology for MacAddress. I think NTDoc addresses multiple Nic/Adapters in his Helpdesk scripts as well.
Pure SQL, just keep whittling away on it and we'll get you there. 
Kent
