MySQl Query Required

Question

I have one table

ID    Details   User_id Last_ID
2960    ABC     52294
10532   PQR     61629   61629
11050   XYZ     69

and other

Id    UserName
69      aaaa
52294   bbbb
61629   cccc

Please provide a query to get following data

ID    Details   UserName last_id

Perform JOIN over your tables – Alekhya Vemavarapu Feb 18 '16 at 10:38 — Alekhya Vemavarapu, Feb 18 '16 at 10:38
What query have you tried? what does the result look like? – Jeff Feb 18 '16 at 15:05 — Jeff, Feb 18 '16 at 15:05

score 1 · Answer 1 · edited Apr 19 '16 at 09:09

1

Query:

SELECT a.ID, a.details, b.UserName, a.Last_ID
FROM one_table as a,
INNER JOIN other_table as b ON b.id = a.user_id

edited Apr 19 '16 at 09:09

Nijin22

answered Feb 18 '16 at 10:40

Pathik Vejani

score 0 · Answer 2 · answered Feb 18 '16 at 10:39

0

SELECT d.ID, d.Details, u.UserName 
FROM details d, usernames u 
WHERE d.User_id = u.Id

answered Feb 18 '16 at 10:39

mitkosoft

1

Please avoid posting answers with implicit join syntax, always teach users to use the proper syntax of joins! – sagi Feb 18 '16 at 11:03

score 0 · Answer 3 · answered Feb 18 '16 at 10:40

0

select T1.id ,t1.details,t2.userName 
from t1
inner join t2 on t1.user_id =t2.id

answered Feb 18 '16 at 10:40

Ankit Agrawal

score 0 · Answer 4 · edited Feb 19 '16 at 02:29

0

select
    a.id,a.details,b.username
from
    first_table a,second_table b
where 
    a.userid = b.id

edited Feb 19 '16 at 02:29

Nisse Engström

answered Feb 18 '16 at 11:26

Priyanshu

I have made certain changes to my question... Could you please check – Salil Lambay Feb 19 '16 at 03:51

4 Answers4