Hi everyone, I need help for query writing , can you please help me?

Database
Highlighted
Enthusiast

Hi everyone, I need help for query writing , can you please help me?

 I want to run a query which includes all records from BVC_card.cda_prk_bvr_kin 

and join on 4 below tables on customer_id Prack_IDNTFCTN_NUM

 

brc_edw_prok_bulk.cust_bu_bsb_app
brc_edw_prok_bulk.cust_bu_er
brc_edw_prok_bulk.cust_bu_ex
brc_edw_prok_bulk.cust_bu_kc

Finally i need to get 55K records from BVC_card.cda_prk_bvr_kin.

can someone please help me? its urgent.