引用: 表記ゆれも修正させていただきました、ありがとうございます。
どこをどう修正したのか( 各フィールドの正しい名前は何なのか)を
具体的に明記して下さい。
引用: わかりづらくてすいません、社員IDになります。
-------------------------------
誤 正
-------------------------------
ID -> 社員ID
戻り1 -> 休憩1終
戻り2 -> 休憩2終
戻り3 -> 休憩3終
-------------------------------
とりあえず、[Test_tb]における各フィールドの名前の正誤関係が
以上のようになっているものと仮定します。
( SQL ビュー)
-------------------------------------------------------------
SELECT [UQ].[社員ID],
[UQ].[日付],
[UQ].[休憩ID],
[UQ].[休憩],
[UQ].[休憩終]
FROM (SELECT [Test_tb].[社員ID],
[Test_tb].[日付],
1 AS [休憩ID],
[Test_tb].[休憩1] AS [休憩],
[Test_tb].[休憩1終] AS [休憩終]
FROM [Test_tb]
UNION ALL
SELECT [Test_tb].[社員ID],
[Test_tb].[日付],
2 AS [休憩ID],
[Test_tb].[休憩2] AS [休憩],
[Test_tb].[休憩2終] AS [休憩終]
FROM [Test_tb]
UNION ALL
SELECT [Test_tb].[社員ID],
[Test_tb].[日付],
3 AS [休憩ID],
[Test_tb].[休憩3] AS [休憩],
[Test_tb].[休憩3終] AS [休憩終]
FROM [Test_tb]) AS [UQ]
WHERE [UQ].[社員ID] Is Not Null
AND [UQ].[休憩] Is Not Null
ORDER BY [UQ].[社員ID],
[UQ].[日付],
[UQ].[休憩ID];
-------------------------------------------------------------
|