Re: [Emerald] Emerald & Mailsite Lists

Dale E. Reed Jr. ( (no email) )
Thu, 01 Jul 1999 12:25:35 -0700

PowerNet wrote:
>
> I have nothing in the SQL statement.
>
> What should I put?

You need to put something in there to select the user data from
your Emerald database. Here is an example that should work:

Select EMail=Login + '@' + d.MailDomain, FullName=sa.FirstName + ' ' +
sa.LastName