I have a main table and a small lookup table.
Im trying to get the ids from my streets table to my benchmarks table.
So in streets I have 2 columns.
In Benchmarks I have a streetid field that I want to contain the value of the Id column in streets table. I need to use Streets.Streetname and Benchmarks.Street1 as the where.
So in psuedo code:
update dbo.benchmarks set dbo.benchmkarks.street1id = dbo.streets.id where dbo.benchmarks.street1id = dbo.streets.streetname.
Obviously this will take a loop to read in all the rows in streets and then do the processing unfortunately ive never grasped fully how to get this right in sql.
Thanks in advance and please view the attachment that shows my columns.