On Fri, 31 Jan 2020 14:01:17 +
Geoff Winkless wrote:
> a | c | c
> +-+-
> 1 | 111 | 211
> 1 | 112 |
> 2 | 121 |
> 2 | | 222
> 3 | |
> 4 | 141 |
> 5 | | 253
> 6 | |
> 7 | |
> 8 | |
> 9 | |
> 10 | |
The c's look just like
On Fri, 31 Jan 2020 14:01:17 +
Geoff Winkless wrote:
> Hi
>
> I have a query involving multiple tables that I would like to return
> in a single query. That means returning multiple sets of the data
> from the first base table, but that's acceptable for the simplicity
> in grabbing all the d
On Fri, 31 Jan 2020 at 15:25, David G. Johnston
wrote:
> On Friday, January 31, 2020, Geoff Winkless wrote:
>
>> Now the problem is that I would like to return all the rows from a, but
>> with a single row where t2.b and t1.b match.
>>
>
> So, the final,number of rows for each “a” is the larger
On Friday, January 31, 2020, Geoff Winkless wrote:
> Now the problem is that I would like to return all the rows from a, but
> with a single row where t2.b and t1.b match.
>
So, the final,number of rows for each “a” is the larger row count of “b”
and “c” having the same “a”. Furthermore for the
