c# - Join the result of 2 queries(make it in 1 query preferable) -

so have 2 queries score of football team 1 table

query 1

select sum(score_thuis) `wedstrijden` `gespeeld` = 1 , thuis_team = 'team 14' 

query 2

select sum(score_uit) `wedstrijden` `gespeeld` = 1 , uit_team = 'team 14' 

is there way can 1 query , result of above 2. have experienced alot sum command did combine score of opponents team aswell or give result in 2 rows :/

select sum(score_thuis), sum(score_uit) wedstrijden `gespeeld` = 1 , (thuis_team = 'team 14' or uit_team = 'team 14')