How do I do a nested Select in Crystal Reports 10?

For example:
select IH.ItemNo,
       IH.CageCd,
       (select top 1 barcodeid ID
        from itemdtl ID
        where ID.ItemNo = IH.ItemNo
          and ID.CageCd = IH.CageCd) as BarCodeID
from itemhdr IH

djnnllAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
shivkasiConnect With a Mentor Commented:
Use sub report for itemdtl  and link  Main report with Item No.
you can place the the sub report in detail section or Groupheader(split into 2 sections) of item No.
0
 
zephyr_hex (Megan)DeveloperCommented:
are you receiving an error when you use that as your SQL Command query?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.