+ 1

[CLOSED]how to assign the minimum date of Table B to Table A

A_MST A_GAMEN_NO A_START_DATE 008 null 009 null 010 null B_MST B_BANNER_NO B_START_DATE 008 2018/4/5 008 2018/4/4 009 2018/4/2 010 2018/4/3 What I need is: A_MST A_GAMEN_NO A_START_DATE 008 2018/4/4 009 2018/4/2 010 2018/4/3

8th Apr 2018, 1:41 AM
Jeff
Jeff - avatar
2 Respuestas
+ 1
select a_gamen_no, min(b_start_date) from b_mst inner join a_mst on a_banner_no=a_gamen_no group by a_gamen_no
8th Apr 2018, 2:41 AM
🇮🇷 M N
0
🇮🇷 M N, thank you for your answer :)
8th Apr 2018, 5:34 AM
Jeff
Jeff - avatar