Skip to Content
avatar image
Former Member

Query

Hi

I have 1 record in inv1 table

docnum1 , docentry 1 , doctotal 1000

In Inv2 table

docentry1 qty 1 itemcode 101

docentry2 qty 1 itemcode 102

In query i want item description of Itemcode1 & Itemcode should be displayed i 1 column .

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jun 23, 2010 at 06:19 AM

    Hi,

    Your question is not very clear. Only OINV has DocTotal and INV1 has ItemCode.

    You may need something like:

    SELECT T0.ItemCode' 'T0.Dscription FROM INV1 T0

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Manish.......

      I think you want column sum of item description right?

      But How its possible as its a description?

      Regards,

      Rahul

  • avatar image
    Former Member
    Jun 23, 2010 at 07:26 AM

    Closed , if it is not possible. Thanks everybody for the time .

    Add comment
    10|10000 characters needed characters exceeded