Select values from same column with different names

tosa · #1 (**permalink**) 04-01-10, 08:57

Hi!

I have tables Customer and SalesLine. SalesLine has OrderCustNumber, InvoiceCustNumber and DeliveryCustNumber which correspond to CustomerNumber in table Customer. I want to select CustomerName from table Customer. How do I select 3 values from column CustomerName?

I'm using a Progress database.

Thanks!

r937 · #2 (**permalink**) 04-01-10, 10:12

if progress supports sql similar to other databases, all you need to do is use three different joins to the customer table using table and column aliases

Code:

SELECT o.CustomerName AS order_customer
     , i.CustomerName AS invoice_customer
     , d.CustomerName AS delivery_customer
  FROM SalesLine
INNER
  JOIN Customer AS o
    ON o.CustomerNumber = SalesLine.OrderCustNumber
INNER
  JOIN Customer AS i
    ON i.CustomerNumber = SalesLine.InvoiceCustNumber
INNER
  JOIN Customer AS d
    ON d.CustomerNumber = SalesLine.DeliveryCustNumber

tosa · #3 (**permalink**) 04-07-10, 01:24

Thank you! Works fine.

Internet Services

Web Development

Digital Marketing

Consumer Tech