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
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
data in one hit.
An example set:
CREATE TABLE t1 (a int, b int, c int)
