Hello I have one Project number 0110 in one table but in other table its 0110A-B so when i do a join between these 2 tables with proj number the above example wont come in the output..so how can i get the above ex also in my output
asked Jul 10 at 08:32 AM in Default
You will have to define how these 2 project numbers can differ. Is it always 'A-B' that's added to the end? Or could it differ? Is the project number always 4 digits? Does the 4 digit project number always start the value in the other table?
This will help you decide how to make the join condition, so it for example it could be
or something else
answered Jul 10 at 08:58 AM
Kev Riley ♦♦