A where between two tables

[#1]

name	ticket_number	quantity	date
marie	96	15	2013-10-17
steven	96	5	2013-10-17
ann	53	1	2013-10-15
josh	88	5	2013-10-10

date	winner_number
2013-10-17	96
2013-10-15	53
2013-10-10	88

So I have a ticket system where a person can buy as many as they want, the other table registers the winner number and the date. Is there a way to store in a variable and/or table the sum() of the quantity of winner_number given a date?

I have done this easily on mysql (Select sum(quantity) from buyer where ticket_number=winner_table.winner_number) but is giving me a hell here because I'm somewhat new.

Thanks in advance for your help.

[MayilVahanan · Accepted solution]

Hi

PFA

[#3]

Hi

It looks like the sum(quantity) as expression will give 20

Is that what you want?

Chris

[preminqlik]

=Sum(quantity)