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

Question

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

Answer 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

Answer 2

🇮🇷 M N, thank you for your answer :)