Reply to thread

Message: <blockquote data-quote="MihiCherub" data-source="post: 16002856" data-attributes="member: 238676">මේ Table තුනම join කරල දෙන්න පුලුවන්ද තනි query කින්. <img src="/styles/default/xenforo/smilies/default/confused.gif"  class="smilie" loading="lazy" alt=":confused:" title="Confused    :confused:" data-shortname=":confused:" />(*)Indicates PK -- invoicedetails table - invoiceno - FKExpected Result -   inv.itemcode, itd.itemname, inv.saleprice, inv.qty AS curentq, fis.qty AS freeq,ret.qty AS returnq, discount,amount  where invoiceno = '1'<img src="/styles/default/xenforo/smilies/default/eek.gif"  class="smilie" loading="lazy" alt=":eek:" title="eek    :eek:" data-shortname=":eek:" />-----------------------0001,Pen,12.00,2,1,0,1.50,10.50මම ගැහුවෙ මෙහෙම එකක්. ඒත් freeitems ගාන එන්නෙ වැරදියට. සමහර invoice වල items ගාන repeat වෙනව.[CODE]SELECT   inv.itemcode,  itd.itemname,  inv.saleprice,  inv.qty AS curentq,  fis.qty AS freeq,  ret.qty AS returnq,  discount,  amount FROM  invoicedetails inv   INNER JOIN itemdetails itd     ON inv.itemcode = itd.itemcode   LEFT JOIN freeissue fis     ON inv.invoiceno = fis.invoiceno   LEFT JOIN returnitems ret     ON inv.invoiceno = ret.invoiceno WHERE inv.invoiceno = '1' [/CODE]තව පැහැදිලි කරන්න කියන්න එපා <img src="/styles/default/xenforo/smilies/default/angry.gif"  class="smilie" loading="lazy" alt=":angry:" title="Angry    :angry:" data-shortname=":angry:" /><img src="/styles/default/xenforo/smilies/default/angry.gif"  class="smilie" loading="lazy" alt=":angry:" title="Angry    :angry:" data-shortname=":angry:" /><img src="/styles/default/xenforo/smilies/default/angry.gif"  class="smilie" loading="lazy" alt=":angry:" title="Angry    :angry:" data-shortname=":angry:" /></blockquote>

Verification: Awruddata maasa keeyada?

Top Bottom