fetch firstname using userID from another table

Question

I have following mysql table: Table Name:PaymentHitory

journeyID | passengerID  | driverID 
---------------------------  
1         |    1         |3  
2         |    2         |4

Table Name:UserInformation

userID | firstName
------------------
1      |    ABC         
2      |    XYZ        
3      |    PQR         
4      |    MSN

I want result like

 journeyID | passengerName  | driverName 
------------------------------------------  
    1      |    ABC         |PQR  
    2      |    XYZ         |MSN

driverName is not in all the two tables,then how will you retrieve that — Vaisakh Parannattil Cherul
– Vaisakh Parannattil Cherul, Commented Jun 20, 2014 at 9:47

RemyG · Accepted Answer · 2014-06-20 09:48:51Z

4

It's a simple join on the tables:

select journeyID, pax.firstName as passengerName, dri.firstName as driverName 
    from PaymentHistory pay 
    join UserInformation pax on pay.passengerID = pax.userID 
    join UserInformation dri on pay.passengerID = dri.userID

answered Jun 20, 2014 at 9:48

RemyG

4965 silver badges11 bronze badges

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

1 Comment

Vishal Patel Over a year ago

@GordonLinoff Sure !! You will get credit from question owner.

Collectives™ on Stack Overflow

fetch firstname using userID from another table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related