回答編集履歴
3
追記
test
CHANGED
@@ -2,7 +2,7 @@
|
|
2
2
|
|
3
3
|
```sql
|
4
4
|
|
5
|
-
SELECT
|
5
|
+
SELECT ID, 氏名, 誕生日,
|
6
6
|
|
7
7
|
DMAX( "参照日付", "テーブルA", "参照日付 <= " & format([テーブルB].[誕生日],"\#yyyy/mm/dd\#")) as 基準日付
|
8
8
|
|
@@ -16,10 +16,14 @@
|
|
16
16
|
|
17
17
|
```sql
|
18
18
|
|
19
|
-
SELECT B.
|
19
|
+
SELECT B.ID, B.氏名, B.誕生日, (select top 1 A.参照日付 from テーブルA as A where A.参照日付 <= B.[誕生日] order by A.参照日付 desc) AS 基準日付
|
20
20
|
|
21
|
-
(select top 1 A.参照日付 from テーブルA as A where A.参照日付 <= B.[誕生日] order by A.参照日付 desc) as 基準日付
|
22
|
-
|
23
|
-
FROM テーブルB
|
21
|
+
FROM テーブルB AS B;
|
24
22
|
|
25
23
|
```
|
24
|
+
|
25
|
+
|
26
|
+
|
27
|
+
#追記
|
28
|
+
|
29
|
+
クエリ両方直した。基準日付の名前ダブるのだめみたいね。
|
2
修正
test
CHANGED
@@ -16,7 +16,7 @@
|
|
16
16
|
|
17
17
|
```sql
|
18
18
|
|
19
|
-
SELECT
|
19
|
+
SELECT B.*,
|
20
20
|
|
21
21
|
(select top 1 A.参照日付 from テーブルA as A where A.参照日付 <= B.[誕生日] order by A.参照日付 desc) as 基準日付
|
22
22
|
|
1
微修正
test
CHANGED
@@ -18,7 +18,7 @@
|
|
18
18
|
|
19
19
|
SELECT テーブルB.*,
|
20
20
|
|
21
|
-
(select top 1 参照日付 from テーブルA as A where 参照日付 <= B.[誕生日] order by 参照日付 desc) as 基準日付
|
21
|
+
(select top 1 A.参照日付 from テーブルA as A where A.参照日付 <= B.[誕生日] order by A.参照日付 desc) as 基準日付
|
22
22
|
|
23
23
|
FROM テーブルB as B
|
24
24
|
|