Update table based on a list on another table

[Mackbear]

Hello all, good day! I apologize if I am opening up a lot of thread lately, just can't figure out how to do stuff...I really appreciate your help everyone!

So I have a list of let's say approved companies. I would like to update a field on a table based on this list. I have a company name field on that table and an approved field. I would like to update the approve field to have a value "Yes" if the company name on the table is on the list. How do I do it?

 

[theDBguy]

Hi. You would use an UPDATE query. You can join the two tables in your query and update the approved field.

 

[Mackbear]

Yes, update query but how do I make it reference the other table? I'm sorry I can't seem to construct it... I am up until
UPDATE tbl_info WHERE...

And I don't know how to proceed from there... because the WHERE only looks for one value, do I add a dllookup on it? Having difficulty constructing it.

 

[theDBguy]

Yes, update query but how do I make it reference the other table? I'm sorry I can't seem to construct it... I am up until
UPDATE tbl_info WHERE...

And I don't know how to proceed from there... because the WHERE only looks for one value, do I add a dllookup on it? Having difficulty constructing it.

Hi. Yes, you can do it using a WHERE clause, but I was saying it's easier/simpler just to JOIN the two tables. For example:

UPDATE Table1 INNER JOIN Table2 ON Table1.CompanyName=Table2.CompanyName SET Table1.Approved=True

Hope it helps...

 

[Mackbear]

Hi. Yes, you can do it using a WHERE clause, but I was saying it's easier/simpler just to JOIN the two tables. For example:

UPDATE Table1 INNER JOIN Table2 ON Table1.CompanyName=Table2.CompanyName SET Table1.Approved=True

Hope it helps...

Thanks for thissss this is exactly what I need!

 

[theDBguy]

Thanks for thissss this is exactly what I need!

Hi. You're very welcome. Glad we could assist. Good luck with your project.