I am trying to create a view and by linking two tables together, VLP_QC_Results_Batch1000 and VLP_Stock_QC1000. (see below pics)
The issue I have is in the VLP_QC_Results_Batch1000 has the testNo within a field called TestNoName and is separated by a “-“
I need to link these so that we can show the upper and lower limit for each test and the test results
I am unsure if i can link on the BatchID and the QCID as I don’t know how these tables interact with each other.
Is there a simple way to get all the characters before the “-“ from the TestNoName field? I could trim it but the TestNo is different sizes.