Search results for query: *

Would I just replace the FROM statement in my SQL with your from statement? I really don't care about the sorting as long as the report contains only the values from the UMUIMPDwDED table matched to the corresponding values from the other table and the values that do not have a match be matched...

Desired Results would have the values 3500, 5000, 7500 & 10000 have the fourth & fifth columns as: 15000 -1 495201 15000 250 N A 15000 250 495201 15000 250 N N I wish there were someway to post the DB itself as these are the only tables & query in it it is...

Actual results: UMUIMPDwDED_Field1 UMUIMPDwDED_Field2 Field3 Expr3 UMUIMPDwDED IMPORT_Field2 Expr1 Expr2 -1 -1 495200 -1 1 N A -1 * 495200 -1 1 N M 0 -1 495200 0 1 N A 0 * 495200 0 1 N M 3500 -1 3500 A 3500 250 3500 M 3500 * 3500 M 5000 -1 5000 A 5000 250 5000 M 5000 * 5000 M...

Sorry, I understand it was confusing. There are two tables within the previous past. within the first table (UMUIMPDwDED) I have two columns of information. In the second table (UMUIMPDwDED IMPORT) I have three columns of information. And the last item is a query named (UMUIMPDwDED Query) and...

(UMUIMPDwDED) Field1 Field2 * -1 * 250 * * 0 -1 0 * -1 -1 -1 * 10000 -1 10000 250 10000 * 100000 -1 100000 250 100000 * 1000000 -1 1000000 250 1000000 * 15000 -1 15000 250 15000 * 150000 -1 150000 250 150000 * 20000 -1 20000 250 20000 * 200000 -1 200000 250 200000 * 25000 -1 25000 250 25000 *...

I am trying to run a query to combine 2 tables. The relationship is one that includes all values from one table and only the values from the other table that match. This is the problem. I want the values that do not have an exact match from the first table to show the next higher value from the...