??? ?? ??? ??(?? 5? ??)? ????.
??? | ?? | 1? | 2? | ?? 1 | ?? 2 |
---|---|---|---|---|---|
2022? 11? 21? | 0:01 | 1668969012 | 413027032418217 | B3B820CE | |
2022? 11? 21? | 0:02 | B3B820CE | |||
2022? 11? 21? | 0:03 | 1668969013 | 413027032418218 | 8EFCB769 | |
2022? 11? 21? | 0:04 | 8EFCB769 | |||
2022? 11? 21? | 0:05 | 1668969014 | 413027032418219 | 4070A788 |
????? ?? ? ?? ??? ? ?? key1? key2? ???? ???? ??? ? ????. ??? ??? ???? ???? ??? ????.
????? ? ?? ????? ??? ?? ? ???? ???? ???.
??? | ?? | ??? | ?? | 1? | 2? |
---|---|---|---|---|---|
2022? 11? 21? | 0:01 | 2022? 11? 21? | 0:02 | 1668969012 | 413027032418217 |
2022? 11? 21? | 0:03 | 2022? 11? 21? | 0:04 | 1668969013 | 413027032418218 |
2022? 11? 21? | 0:05 | 1668969014 | 413027032418219 |
??? ?? ???? ??? ????. ??? ??? ?? ??? ?? ???? ????. ??? ??? ??? ???? ?? ? ? ?????
SELECT t1.start_date_time, t2.start_date_time AS end_date_time, t1.number1, t1.number2 FROM details_all AS t1 JOIN details_all AS t2 ON t1.key1 = t2.key2
??? ?????. INNER JOIN? ??? ?? ?????.
?? ? ?? ??? ?? ??? ??? ?? ? ?? ???? ???? ???.
??? key1
值始終存在,而 key2
? ??? ?? ??? ??? LEFT JOIN? ??? ? ????.