pitulobo

Posts

Reputation

Joined 16 Years Ago

Last Seen 16 Years Ago

0 Reputation Points

Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements

1 Contribution

Ranked #107.79K

Discussions / Questions x 1

~77 People Reached

Favorite Forums

Databases x 1

Favorite Tags

mysql x 1

1 Posted Topic

sql

16 Years Ago 16 Years Ago

I have 2 tables 1st INVHD 2nd INVDT In INVHD I have following fields InvNo, InvDate,CustCd, CustName, TotalDisc (Discount on total Invoice), GrandTotal In INVDT I have following fields InvNo, RowNo,ItemCode, Qty, Rate, BaseVal, etc…. Now I need a query to be generated for The customer CustCd, CustName, Sum(totalDisc), Sum(GrandTotal) …

Databases mysql

The End.