On 9/12/04 1:20 PM, "Roland Dumas" <[EMAIL PROTECTED]> wrote:
>
> Ok, I came to the conclusion that you can't do a self join using the search
> action. Have to do a direct dbms and create an alias of the table and then
> join it with the actual table.
>
> As in
>
> SELECT recipients.UID, recipients.firstname, recipients.lastname,
> recipients.email, recipients.referrer, senders.firstname, senders.lastname,
> senders.email
> FROM recipients, recipients as senders
>
>
>
> - an SQL greenhorn -
Sorry, forgot to paste the important line:
SELECT recipients.UID, recipients.firstname, recipients.lastname,
recipients.email, recipients.referrer, senders.firstname, senders.lastname,
senders.email
FROM recipients, recipients as senders
WHERE senders.UID = recipients.referrer
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
