I want to view the table 1 and sum of table2 report

Paresh Patel

in Crystal Report Windows application

table 1

id name

001 raja

002 vijay

003 suresh

table 2

id value

 001 100

001 200

001 150

002 200

003 150

003 200 ...

Expected Out Put:

id name value

001 raja 450

002 vijay 200

003 suresh 350

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Paresh Patel11y ago
i already use this query but how can i display in crystal report
0
Paresh Patel11y ago
i already use this query but how can i display in crystal report
0
Rahul Prajapat11y ago
hello @paresh try this code

select Table_1.id,Table_1.name,sum(Table_2.value) Total from Table_1
inner join
Table_2
on
Table_1.id=Table_2.id
group by Table_1.id,Table_1.name

if get any problem please reply..
0