I realize you can't do a count distinct with partition by so I'm looking for a workaround. How do I combine the 2 tables to give me the result table? Thank you!
Table 1 Table 2 Result PNR AAA PNR Orig PNR AAA Orig (count distinct OrigAB 1a AB IAH AB 1a 2AB 2a AB IAD AB 2a 2
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.