Join Help

From: Kram <kram_at_biosys.net>
Date: Wed, 1 Sep 1999 20:52:06 -0400
Message-ID: <7qkhpc$gp1$1@bgtnsc03.worldnet.att.net>

I need some help with a join?

I neeed to be able to convert the "receiver" and the "customername" into the salesperson numbers which reisde in my salesperson table. The only relation is the username. The result of the select would be as follows:

1 administrator, Nike Corporation, Mike

insert into MyTable (pubno,receiver,customername,salesno) select (a.additiono,s.salesno,s.salesno,c.salesno) from addittion a, salespersons s, newcustomers c where a.cusnumber=c.cusnumber
and upper(a.receiver)=upper(s.username) and upper(a.cusname)=upper(s.username)

How do I tell the system in the select s.salesno(should be a.receiver number),s.salesno (should be a.receiver)????????

Any help would be greatly appreciated.

Kramer Stroud Received on Wed Sep 01 1999 - 19:52:06 CDT