join of 2 tables into 1

[pelegk2]

i have a :

table1 :

YEZUR_SIDRA varchar(7)
p_makat_raw varchar(20)
kamut_s varchar(20)
KAMUT_S varchar(20)

table2 :

YEZUR_SIDRA varchar(7)
p_makat varchar(5)
end_weight float

and i want to get this result :
table1 .p_makat_raw combined with table2.makat in the same column
second column : YEZUR_SIDRA
third : SUM(end_weight )
forrsth : SUM(KAMUT_S)

is this possible?
thnaks in advance
peleg

[_RL_Ian]

Sure it is. Take a look at the UNION Syntax for MySQL. This should get you rolling in the right direction.