Select two different values from same field

[budimir]

I need help. Is it possible to do this kind of query:

SELECT * FROM katalog_pribora_povijest WHERE Br_artikla = '544 90 90-01' AND Br_artikla = '578 44 65-01' GROUP BY godina

Columns in DB are:

 

Id

Br_artikla (article number)

Godina (year)

Prodana_kolicina (qty)

date

 

I would like to select both numbers, group them by year and sum the qty.

 

How can I do that?

 

 

 

[Barand]

A record cannot have a article number that at is both A and B, but it can be A or B

SELECT Godina, SUM(Prodana_koicina) as Total
FROM katalog_pribora_povijest
WHERE Br_artikla IN ('544 90 90-01', '578 44 65-01')
GROUP BY godina

[budimir]

Excellent, Barand!

 

That is the solution!

 

Thank you very much.