complicated join

  • Thread starter Thread starter Derek
  • Start date Start date
D

Derek

Hello,

I'm sure this one has been asked and answered but I can't figure it out. I
have an update query where I need to join a range of records. Based on an ID
number greater than "X"

I know I am going to have to use SQL

and I think it would look something like this... but I am getting an error
message

SELECT [tmpImportSales]![Region] AS updateregion
FROM tmpImportSales INNER JOIN [RegionUpdate] ON tmpImportSales.ID >
[RegionUpdate].ID;

Any help would be greatly appreciated.

Thank you,
Derek
 
Your question is about an Update Query but you posted the
SQL String of a Select Query???

HTH
Van T. Dinh
MVP (Access)
 
Thanks for your help..

Well I want to run the select first so I can check that I am pulling the
right data.
The original problem was a syntax error. That has been resolved.

Right now I'm dealing with the problem of the range of values that are being
linked.

because of the logic, if there is an id 7 and an id on the first table Id's
greater than 9 in the second table are being linked with id 7 in the first
table. Is there a way to specify only 1 link for each item in table 2?

-Derek
 
Thanks so much for your help... if you get a chance to think about it... I
sure could use some guidance.

Thanks,
Derek
 
Back
Top