Home > database >  The small white want to ask next the two SQL is the same effect
The small white want to ask next the two SQL is the same effect

Time:11-20

Did find the ministry door staff

CodePudding user response:

Statements 1
?? The select DName from tb_Depart where DID='01 and tb_Depart. DID NOT in (select dinstinct from tb_Depart INNER JOIN tb_? The person ON tb_Depart. DID=tb_? Person. DID)
Statements 2
Select * from tb_person where DID='01'

CodePudding user response:

Why each time all say me contain special characters, can only be published statements into comments,?????

CodePudding user response:

Certainly is not the same as
Above that of the query is 01 sector and no one department information, the department returns the department name
The sentence below is 01 sector personnel information query, returns the name, gender, age these

CodePudding user response:

Don't say first, could you run the SQL to determine?
  • Related