Replacing multiple columns with query from another

[quote='srl309' pid='146' dateline=' ***-***-**** '] i dont know why the joins aren't working it looks like they are cross joins and thats why they are returning 3 values you can probably do it like below: [code] select * from presentation_schedule WHERE problem_set IN(select person_id from members) OR literature IN(select person_id from members) OR research IN(select person_id from members); UPDATE presentation_schedule SET problem_set = (SELECT name FROM members WHERE members.person_id = presentation_schedule.problem_set), literature = (SELECT name FROM members WHERE members.person_id = presentation_schedule.literature), research = (SELECT name FROM members WHERE members.person_id = presentation_schedule.research); [/code] [/quote] Thanks for the response srl, I think I misspoke or didn't communicate what I was looking for properly. I'm not looking to update the presentation database with the names of the member database. I can see when I said "replace" that might have been implied. What I am looking for really is a query that I can turn into a VIEW such that the presentation, literature and research columns are replaced by the names in the member table without any post-processing by me. Right now, I have to do two queries, one to pull the members and the other to pull the schedule, then manually loop through the schedule array and replace all instances of the person_id with the name. Right now it is ok, but as the members and schedule length grows this will become increasingly slow So something with the following table output:[code] date problem_set literature research 1/4 4 8 1/8 9 2[/code] Might be replaced by:[code] date problem_set literature research 1/4 person_4 person_8 1/8 person_9 person_2[/code] I do see how the code you provided would allow me to update the presentation_schedule table with the names from members. But I don't think I can translate that to a correct select statement to display. I was trying to think of how I could do an intersection between some various queries to generate the table I needed, and maybe a group_by the date. Going to play around with a few options, but any ideas or help is really appreciated. I took one DB course, and am trying to extend that knowledge to these more complex needs.

Replacing multiple columns with query from another