Hi,
IF ANYONE CAN POINT OUT THE OBVIOUS TO ME I AM COMPLETE BEGINNER COVERING FOR AN RECENTLY LEFT I.T. EXPERT.
THIS QUERY PRODUCES NO ROWS ALTHOUGH WHEN I SEARCH FOR THE FIRST FEW user_sampleid INDIVIDUALLY THEY ARE ALL GENERATING ROWS.
THERE ARE MANY MORE user_sampleid IN MY FULL QUERY. IS IT THAT ONE IS NOT A VIABLE SEARCH AND THAT RUINS THE REST OF THE QUERY RETURN?
select SAMPLE_ID, USER_SAMPLEID, CONTAINER_NAME, POSITION, SAMPLE_TYPE, VISIT, LOCATION
from IAVI_CONTAINER_SAMPLES where user_sampleid like ('B00202004%PBMC%'',
''B00202022%PBMC%'',
''B00422050%PBMC%');
MANY THANKS