table items
barcode
quantity
price
id
table serial_number
barcode
serial_number
id
table items_out
barcode
serial_number
quantity
price
id
i have three table just like i describe above. if i choose a barcode and quantity=2 from table items and i want to move 2 serial_number from table serial_number to table items_out, how to write it in sql?