Re: How to write a crosstab which returns empty row results

2022-12-25 Thread David Goldsmith
*That* covers this. On Sun, Dec 25, 2022 at 8:56 AM David Goldsmith wrote: > > > Thanks, David. There's a lot of stuff i'm not familiar with in there: I > don't suppose you know of a tutorial they covers this? > > > On Sun, Dec 25, 2022 at 8:46 AM

Re: How to write a crosstab which returns empty row results

2022-12-25 Thread David Goldsmith
Thanks, David. There's a lot of stuff i'm not familiar with in there: I don't suppose you know of a tutorial they covers this? On Sun, Dec 25, 2022 at 8:46 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Sun, Dec 25, 2022 at 12:25 AM

Re: How to write a crosstab which returns empty row results

2022-12-24 Thread David Goldsmith
ot;2021" TEXT ); A row for each one of the matching s.s_id values should be displayed, even if all the ad.s_a_qty values for that Yr are NULL; right now, the query works, but it only returns matching rows for which at least one year has a non

How to write a crosstab which returns empty row results

2022-12-24 Thread David Goldsmith
Hi. New subscriber and intermediate level SQL writer here, still pretty new to Postgresql (but I don't know how to do the following in TSQL either). I've figured out how to write a crosstab query I need; the problem is that the number of row results should be 72, but I'm only getting 41. I'm pret