Concat 열의 한 테이블의 각 항목의 다른 테이블

0

질문

나는 날짜에 하나의 테이블:

2021-10-01
2021-10-02

및 코드는 다른 테이블:

0101
0102

내가 원하는 결과를보:

2021-10-01 - 0101
2021-10-02 - 0101
2021-10-01 - 0102
2021-10-01 - 0102

변환하여 추가 모든 코드를 각각 날짜에 마지막으로 테이블이 각각의 날짜는 코드입니다.

Date 테이블을 쿼리:

Select DATE from Table1

코드 테이블을 쿼리:

Select CODE from Table2
sql sql-server tsql
2021-11-24 06:43:45
1

최고의 응답

2

사용 십자가 참여:

SELECT CONVERT(varchar(10), t1.date, 120) + ' - ' + t2.code
FROM Table1 t1
CROSS JOIN Table2 t2
ORDER BY t2.code, t1.date;

데모

2021-11-24 06:47:17

다른 언어로

이 페이지는 다른 언어로되어 있습니다

Русский
..................................................................................................................
Italiano
..................................................................................................................
Polski
..................................................................................................................
Română
..................................................................................................................
हिन्दी
..................................................................................................................
Français
..................................................................................................................
Türk
..................................................................................................................
Česk
..................................................................................................................
Português
..................................................................................................................
ไทย
..................................................................................................................
中文
..................................................................................................................
Español
..................................................................................................................
Slovenský
..................................................................................................................