SELECT invpost.salesrep1 as salesrep, PADR(ALLTRIM(salesrep.fname) + ' ' + ALLTRIM(salesrep.lname),50) as repname FROM invpost JOIN salesrep on invpost.salesrep1 = salesrep.salesrep WHERE NOT EMPTY(invpost.salesrep1) UNION SELECT invpost.salesrep2 as salesrep, PADR(ALLTRIM(salesrep.fname) + ' ' + ALLTRIM(salesrep.lname),50) as repname FROM invpost JOIN salesrep on invpost.salesrep2 = salesrep.salesrep WHERE NOT EMPTY(invpost.salesrep2) UNION SELECT invpost.salesrep3 as salesrep, PADR(ALLTRIM(salesrep.fname) + ' ' + ALLTRIM(salesrep.lname),50) as repname FROM invpost JOIN salesrep on invpost.salesrep3 = salesrep.salesrep WHERE NOT EMPTY(invpost.salesrep3) ORDER BY 1 INTO CURSOR curRep>Still learning SQL so after a few google searches giving no good results, I figured I would bug the experts. I am trying to get a list of all the unique salesreps (and their names) used in an order into a cursor. The problem is the reps are in three seperate fields on the table: salesrep1, salesrep2, and salesrep3. I am not sure if I need to use three seperate queries and do some sort of combining or if I can do it all in a 1 select statement. The statement below works great for one of the reps. Any help would be appreciated.