[Cyrius]

Hi guys, I was wondering if you could give me a hand with an SQL query, I am rusty.

I need to show a user's name rather than the integer for their name. For example, the code below is showing 318512 as the user for inside sales on a customer.

I got the key relationship set up right (I think) but I need the columns Inside Sales and Outside sales to show U.First_Name+U.Last_Name.

One other confusing me is the foreign key being tied to two fields.

I used the left outer join because there are some null values in the customer table for both Inside and Outside sales.

SELECT
C.Name AS 'Customer Name',
C.Customer_Status,
C.Customer_Type,
C.Phone,
C.Fax,
C.Out_Sales AS 'Outside Sales',
C.In_Sales AS 'Inside Sales'
FROM Customer AS C LEFT OUTER JOIN User AS U
ON C.Out_Sales = U.User_No
AND C.In_Sales = U.User_No
WHERE Customer_Type = 'Retail'