- Strength to Increase Rep
- +2
- Strength to Decrease Rep
- -0
- Upvotes Received
- 2
- Posts with Upvotes
- 1
- Upvoting Members
- 2
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
Re:
Dear sir, Please help me about below query. here is two table sale and purchase. i want product wise result in output table like below picture. please help me ![22222.jpg](/attachments/large/4/f8a1f4cfc8eaaad4bde70a850826b310.jpg) |
|
Re:
Hi Everyone, I have a real noob question please, I am trying to update a mysql database using the code below, I know the invoice number variable is correct, But for some reason the database is not updating, Can someone point me in the right direction please, I have tried … |
|
Re:
select companyname,sum(sale) as TotalSale,sum(purchase) as TotalPurchase from invoice group by companyname Having companyname IN (select companyname from invoice) It returns sum only for those column whose all sum are not blank, how can i show blank sum values I mean there are 7 companies but only 4 records are shown. … |