find out each bond categories and sub-categories identical bonds

CodePudding user response:

SELECT * FROM TABLE A
WHERE the EXISTS (SELECT 1 FROM the TABLE WHERE the bond code & lt;> A. bond coding (bond coding, 8)=RIGHT AND RIGHT (a. bond coding, 8))

CodePudding user response:

Don't you? A child is different, find out each bond category identical bonds

CodePudding user response:

refer to the second floor nitaiyoucala response:

is wrong? Find out each bond different categories, sub-categories identical bonds

SELECT * FROM TABLE A
WHERE the EXISTS (SELECT 1 FROM the TABLE WHERE the bond categories & lt;> A. bonds bond categories AND sub-categories=a. bonds subcategory)