equipment model rme_eqp_model
manufacturers pub_mfr
equipment pwr_eqp
equipment pwr_eqp
equipment pwr_eqp
- EQP_MODEL_ID primary key EQP_TYPE_ID MFR_ID foreign keys
- the manufacturer MFR_ID primary key EQP_MODEL equipment model eqp_id ID
- eqp_id primary keys

SQL statement above: the select EQP_MODEL, MFR_ID from pwr_eqp where MFR_ID='7114'
Remove duplicate MFR_ID manufacturers and equipment types, EQP_MODE, o great god write a link to update

CodePudding user response:

What do you want to achieve the purpose of the

Query you only see a repeat of the field values are DISTINCT

CodePudding user response:

Associated update who,

Select distinct EQP_MODEL, MFR_ID from pwr_eqp where MFR_ID='7114' can go to heavy,

Then according to the business needs to update

CodePudding user response:

pass by