Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account


Photo

SQL Query

- - - - -

  • Please log in to reply
No replies to this topic

#1
Cyrius

Cyrius

    Newbie

  • Member
  • 41 posts
  • Joined 10-October 11
  • OS:Windows 7 x64
  • Country: Country Flag
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'


How to remove advertisement from MSFN



0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users



How to remove advertisement from MSFN