query ontbrekende jaren weergeven

[janvente]

I have a question about showing the missing values by a query.

Tabelname: Top2000
Fields:Artist, Title, Ranking, Year

Select * from Top2000 order by Artist, Title, Year executes

....
Abba, Dancing Queen, 1720, 2015
Abba, Dancing Queen, 1340, 2016
Abba, Dancing Queen, 1970, 2019
Abba, Money, Money, Money, 870, 2016
Abba, Money, Money, Money, 502, 2017
etc

select distinct Year from Top2000 order by Year
results:
2015
2016
2017
2018
2019


I want to create a query with the following ouput

Abba, Dancing Queen, 2017
Abba, Dancing Queen, 2018
Abba, Money, Money, Money, 2015
Abba, Money, Money, Money, 2018
Abba, Money, Money, Money, 2019

Please, Can anyone help me with this query?

Thanks in advance,
Jan Vente

[Ron Weiner]

Post by janvente
I have a question about showing the missing values by a query.
Tabelname: Top2000
Fields:Artist, Title, Ranking, Year
Select * from Top2000 order by Artist, Title, Year executes
....
Abba, Dancing Queen, 1720, 2015
Abba, Dancing Queen, 1340, 2016
Abba, Dancing Queen, 1970, 2019
Abba, Money, Money, Money, 870, 2016
Abba, Money, Money, Money, 502, 2017
etc
select distinct Year from Top2000 order by Year
2015
2016
2017
2018
2019
I want to create a query with the following ouput
Abba, Dancing Queen, 2017
Abba, Dancing Queen, 2018
Abba, Money, Money, Money, 2015
Abba, Money, Money, Money, 2018
Abba, Money, Money, Money, 2019
Please, Can anyone help me with this query?
Thanks in advance,
Jan Vente

Select * From Top2000
Where Artist = 'Abba'
Order By Artist, Title, Year

Rdub

[Ron Weiner]

Post by Ron Weiner

Post by janvente
I have a question about showing the missing values by a query.
Tabelname: Top2000
Fields:Artist, Title, Ranking, Year
Select * from Top2000 order by Artist, Title, Year executes
....
Abba, Dancing Queen, 1720, 2015
Abba, Dancing Queen, 1340, 2016
Abba, Dancing Queen, 1970, 2019
Abba, Money, Money, Money, 870, 2016
Abba, Money, Money, Money, 502, 2017
etc
select distinct Year from Top2000 order by Year
2015
2016
2017
2018
2019
I want to create a query with the following ouput
Abba, Dancing Queen, 2017
Abba, Dancing Queen, 2018
Abba, Money, Money, Money, 2015
Abba, Money, Money, Money, 2018
Abba, Money, Money, Money, 2019
Please, Can anyone help me with this query?
Thanks in advance,
Jan Vente

Select * From Top2000
Where Artist = 'Abba'
Order By Artist, Title, Year
Rdub

Perhaps I did not read your message carefully enough. I think you want
this:

Select Artist, Title, Year
From Top2000
Order By Artist, Title, Year

Will Bring back all of the records in the table without the Column
"Ranking".

Rdub