troubleshooting Question

T-SQL: How to Pull from One Query Based on Another Query

Avatar of Software Engineer
Software Engineer asked on
Programming Languages-OtherMicrosoft SQL ServerProgrammingScripting Languages* T-SQL
1 Comment1 Solution52 ViewsLast Modified:
Hi There:

Below is my code.  This code is returning no results, because its subquery is not returning any results.

I know for certain that the subquery should be pulling data and, therefore, returning results.  Yes, the main "idea" is to return LOTs that resemble Components.

When I say "resemble", let me give you an example.  506N is a Component, while 506N418G06A-40 is a LOT.  So, I want the subquery to pull 506N418G06A-40 and therefore the full query to display 506N418G06A-40 and other lots that begin with "506N" as results.

Is there something wrong with the syntax of the subquery?  Do I need to add syntax for "trimming" strings or something along those lines?

Thanks!

Software Engineer

SELECT DISTINCT [LOT]
FROM WIPTEST
INNER JOIN IV30200 ON WIPTEST.[INVHDRBATCH] = IV30200.BACHNUMB
AND WIPTEST.[INVHDRDOC] = IV30200.DOCNUMBR
WHERE [FG] = '506'
  AND [FGBATCH] = '50418G12D'
  AND [INVHDRBATCH] = '50418G12D'
  AND EXISTS
    (SELECT DISTINCT [LOT]
     FROM WIPTEST
     WHERE 
	   [LOT] LIKE [Component]+'%')
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros