mysql-test/r/join.result


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

id	id
107	107
75	75
id	count(t2.id)
75	1
107	1
id	count(t2.id)
75	1
107	1
id	catid	stateid	countyid
27	2	12	11
28	2	12	11
29	2	12	25
26	1	6	37
id	catid	stateid	countyid
26	1	6	37
27	2	12	11
28	2	12	11
29	2	12	25
a
1
2