Export multiple IP addresses of the same asset

I have a series of assets that have multiple IPs discovered by Nexpose but when I export a list it only exports the last IP that nexpose saw. Is there a SQL Query that allows you to export a list of all the assets with all the IPs that nexpose saw over time?