SQL Query to get data from two table

Question

Lets say i have one table as below :

Create table tblEvents
(
Eventid int primary key,
EventName nvarchar(20),
UserId nvarchar(5)
)

and second table as :

Create table tblUsers
(
Id int primary key,
UserId nvarchar(5),
Username nvarchar(20),
)

How can i get a new table(or result) which has combined results from both.I am only concerned about tblEvents which should just show the UserName from tblUsers where Userid(of tblEvents) is equal to UserId(of tblUsers). So the final output should be in the below format :

EventId | EventName | UserId | UserName
--------|-----------|--------|---------
        |           |        |

where UserName comes from tblUsers. I cannot change the primary keys on any of the table.

Edit : UserId is not INT and cannot be used as primary-foreign keys

https://technet.microsoft.com/en-us/library/ms191517(v=sql.105).aspx — Felix Pamittan, Aug 20 '15 at 07:16
Shockingly basic SQL question. You should at least learn the basics of SQL before using StackOverflow to ask questions like this. — Mike Gledhill, Aug 20 '15 at 07:18
@MikeGledhill: So RTFM questions are off topic now? I think a simple downvote will suffice... — Zohar Peled, Aug 20 '15 at 07:19

score 1 · Answer 1 · edited Aug 20 '15 at 07:26

1

This will Work. Use simple INNER JOIN.

SELECT te.EventId , te.EventName , te.UserId , tu.UserName
FROM tblEvents te
INNER JOIN tblUsers tu ON te.UserId=te.UserId

edited Aug 20 '15 at 07:26

Felix Pamittan

31,544
7
41
67

answered Aug 20 '15 at 07:22

MUHAMMAD TASADDUQ ALI

387
2
14

score 0 · Answer 2 · answered Aug 20 '15 at 07:16

Query:

select 
    e.Eventid,
    e.EventName,
    e.UserId,
    u.Username
from  tblEvents e
join tblUsers u on e.UserId = u.UserId

If you want to create a new table out of that then:

select 
    e.Eventid,
    e.EventName,
    e.UserId,
    u.Username
into new_table
from  tblEvents e
join tblUsers u on e.UserId = u.UserId

You can read more about creating table using into here

score 0 · Accepted Answer · answered Aug 20 '15 at 07:19

0

Review inner join in SQL and try below query.

SELECT tblEvents.Eventid, tblEvents.EventName, tblEvents.UserId ,tblUsers. UserName
FROM tblEvents INNER JOIN tblUsers ON tblEvents.UserId=tblUsers.UserId

answered Aug 20 '15 at 07:19

viral Pathak

99
3

SQL Query to get data from two table

3 Answers3