full join

is there any full join syntaks in mysql because i have problem
with :
table a
code
001
002
003
table b
code pay
001 $10
002 $5
001 $15

i need the result
code pay
001 $25
002 $5
003 $0

not work if i use left join
plase help

Doesn't look like you need a join. Just

SELECT code, sum(pay)
FROM table_b
GROUP BY code

Then again...if you want the null one's to show up too, gonna need to use ifnull

SELECT code, ifnull(sum(pay), 0)
FROM table_b
GROUP BY code

Something like that....

but code 003 with $0 doesn't exist i need that from table a
how about that ?

I see....and why exactly doesn't left join work? Seems like a perfect left join kinda query to me...

but still 003 $0 didn't show up because in the table_b there's no data 003 $0 but still that code 003 exist even there's no data in table_b thank's

SELECT a.code, ifnull(sum(b.pay), 0)
FROM table_a AS a
LEFT JOIN table_b AS b ON a.code = b.code
GROUP BY a.code

wow i have work it all night long thank's alot
when u come to bali, indonesia let me know i'll take for a ride
thank's again man !

Don't think I'll be there anytime soon....little far away 😃

I've always wanted to move to Eastern Asia and become a cab driver....

(Sorry, cheesy post, just had to do it)

Ash