You can use this statement for your purpose

select '<a href=http://' + PortalAlias.httpalias + '>' + portals.PortalName + '</a>'  as portals  from PortalAlias, portals

Sorry, I tried it on a one portal installation and did not notice the duplication. Here is the correct statement:

SELECT    '<a href=http://' + PortalAlias.httpalias + '>' + portals.PortalName + '</a>' as Portals
FROM         PortalAlias INNER JOIN
                      Portals ON PortalAlias.PortalID = Portals.PortalID

As for having 3 items for each portal, I am not sure why it happens to you.

Did you use the statement exactly as written here?

Could you post what you wrote?

Yehuda

Sure, you can use:

SELECT    '<a href=http://' + PortalAlias.httpalias + '>' + portals.PortalName + '</a>' as Portals
FROM         PortalAlias INNER JOIN
                      Portals ON PortalAlias.PortalID = Portals.PortalID
where portals.PortalName like '%text%'

But if you'll read the module documentation you'll see that you have there a bunch of filters and other tools that you can easily use for various tasks.

Paul Scarlet's site is a good source (obviously) for more info about the module uses.

I see that now  he is charging a subscription fee (rightfully for this great module) for versions over 4.1 but the free module will do the job for you.

Yehuda