troubleshooting Question

SQL Query Syntax

Avatar of rwheeler23
rwheeler23Flag for United States of America asked on
Microsoft SQL ServerSQL
13 Comments1 Solution382 ViewsLast Modified:
I have this query in MS SQL.

select      left(item.ITEMNMBR,18) as ITEMNMBR,left(item.ITEMDESC,101) as ITEMDESC,left(item.ITEMDESC,60) as DESCR60,
            itmp.UOMPRICE as UOMPRICE,left(item.USCATVLS_4,3) as USCATVLS_4,left(item.USCATVLS_5,1) as USCATVLS_5,
            left(item.USCATVLS_6,18) as USCATVLS_6,left(vend.VENDORID,10) as VENDORID,left(vend.VNDITNUM,20) as VNDITNUM
        from IV00101 item
        inner join IV00103 vend on item.ITEMNMBR = vend.ITEMNMBR
        inner join IV00108 itmp on item.ITEMNMBR = itmp.ITEMNMBR
        where itmp.prclevel='STANDARD' order by item.ITEMNMBR

I need to limit the join on the IV00108 table to finding just the first record. Is there a way to specify this limitation?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 13 Comments.
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 13 Comments.
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