Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Sample SQL question

 
Alex gRin
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a table that kind of looks like this



And another table that looks like this


What is the right query to take the firstname lastname from table one and insert it to table 2 so that the name matches with id and would look like this


I tried one query before but it does not matches the info

Thanks
 
Jaikiran Pai
Marshal
Pie
Posts: 10447
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What's the question?
 
Venus Ong
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Alex

I think you may want to explore the Merge function of SQL for this case.

Cheers
Venus
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic