As shown in figure, a and b table field, want to have a, b table data together into c table, but after the summary data is wrong, my SQL is:
The select a.h card, count (a.h card), sum (a.s fje), count (b.h cacd), sum (b.s fje)
From a, b
Where a.h card=b.h card
Group by a.h card;
Pray god guide