I Have 2 table In Sql server 2014
Table A Called = mobile_data
Contains :
id mid mname imei manufactured price date status
1 1 M4 Aqua 78 Sony Experia 6000000 2017-06-10 True
2 2 Storm 30 Blackberry 4000000 2017-06-01 True
3. 3 Galaxy 61 Samsung 5000000 2017-06-09 True
Table B Called = mobile_manufactured
id manufactured create_date status
1 Sony Experia 2017-06-10 True
2 Blackberry 2017-06-01 True
Condition
How To Create Triger For Insert to table mobile_manufactured for field column ( manufactured, create_date,status)
when we insert data for table A (mobile_data) which condition If MobileManufactured haven't not yet.then directly insert into table B
For Example id 3 for Manufactured= Samsung
i hope there is someone to help. thanks
