1) Combining Segments like tables in TSQL. 2) Is DISTINCT available for Segments

Hi all,

is it possible to combine 2 NAV 2009 segments like you can do with 2 SQL Tables?


I have got 2 segments and I want to create a 3rd one which contains contacts that are contained in both segments

Also, is it possible to do an operation similar to TSQL DISTINCT?


I have got a segment containing contacts. Maybe, due to duplicates, or for any other reason, there are
contacts having the same email address.I want to send out a newsletter to each distinct email address,
making sure that each email address will be send only 1 newsletter to.

Thank you very much