SQL: Joining Data from multiple tables

Question

I want to make a SQL query that will link data from two tables, and then relate the data from the second table like this

SELECT CustNo AS 'Customer No.', CompanyName, LiasonNo AS 'Liason'  
FROM Customer

What I want to do, is relate Liason Number to the Employee Number on another table and then have it list that number as the Employee LastName.

Would I use an inner join to do this?

John Woo · Accepted Answer · 2012-11-10 15:40:29Z

3

SELECT  a.CustNo as 'Customer No',
        a.CompanyName,
        b.LastName
FROm    Customer a
        INNER JOIN table2 b 
            ON a.LiasonNo = b.EmployeeNo

answered Nov 10, 2012 at 15:40

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Randy B. Over a year ago

Yeah, I got that far, but how would I make the query show EmployeeNo as the Employee.LastName ?

John Woo Over a year ago

the query above show the lastname of the employee, can you explain your question more?

Randy B. Over a year ago

SELECT CustNo ', CompanyName ,Customer.LiasonNo AS 'Liason' FROM Customer INNER JOIN Employee ON Customer.LiasonNo = Employee.EmpNo AND Employee.EmpNo = Employee.LastName

Randy B. Over a year ago

Doing this, I get the conversion to smallint error. The only data linking the two tables is the LisasonNo = Employee.EmpNo so from EmpNo, I need it to display the actual last name of the Employee on the employee table.

Randy B. Over a year ago

Using SELECT Employee.Lastname and then Innerjoin the LiasonNo = EmpNo Thanks!

|

Collectives™ on Stack Overflow

SQL: Joining Data from multiple tables

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related