Hi Not sure about this ..
I have two tables one with data and one which i want to use for to create the following query.
I want to use table 1 which is joined to table 2 (similar names in both)
Table 1 - looks something like this
name Text
John 5 Light Projector @£150
So it contains a name and a text string eg light projector / heavy projector / med projector with a rate eg @ £200
Table 2 is a list of all the different types of projectors which also have different rates depending on the name of the person.
So table 2 will look like
name type rate
John Heavy projector £300
John Light projector £250
What i need to do is modify the text string on table one as the rate is incorrect - i need it to lookup on table 2 the "name" and the "type" and replace the the rate after the @ sign with the correct rate.
So the output would look like John 5 Light Projector @£250
I cant modify table 1 - as its an output of data which is wrong and need to be modified regularly
Not exactly sure about this one appreciate all the help you can give
Thanks