Mysql-could you write an SQL statement to prescribe five prescriptions

CREATETABLEeng_cf (--- prescription table idVARCHAR (20), -- depart_idVARCHAR (30), departmentVARCHAR (30), bed_noVARCHAR (20 )) ---------------------------------------------- CREATETABLEeng_cf_item (-- the list of prescriptions is the cfidVARCHAR (20), drugVARCHAR (20), d... mysqlsql

Create table eng_cf (--- prescription TABLE
Id VARCHAR (20), -- this id is used
Depart_id VARCHAR (30 ),

Department VARCHAR (30 ),

Bed_no VARCHAR (20 ))

Create table eng_cf_item (-- prescription list, that is, the drug TABLE
Cfid VARCHAR (20 ),
Drug VARCHAR (20 ),
Drug_name VARCHAR (20)

)

It is known that the relationship between the prescription table and the prescription list is one-to-many.
The ID of eng_cf is the same as the cfid of eng_cf_item.
If a prescription uses two CFIDS
What SQL statements are used to prescribe five medicines? Please