How can I join csv file with id only?

[mananzeh]

i have 2 csv file 
first one has name and id
second one has the id only

i can extract the common id but i couldn’t find the query to show the common name using the id

any body can help please?!

[ITWhisperer]

| input csv1.csv
| append [| inputlookup csv2.csv]
| stats values(*) as * by id