the biggest difference is color tempature. They function in a similar manner using electricity to excite different gases. Sodiums burn mor in a red yellow sround 3K color temp and they may contain other eleent( typical mercury) that can broaden thier spectrum
MH basically burn mor to blue again depending on the elements within for 10 to 20 K
Sodium is good for alot of Hydroponics not reef keeping