Ask a joint query of the discourse

Ask a statement for a federated query


As shown in the data sheet
How do you read the data in a? (also read out the corresponding data in B)

Share to:

------Solution--------------------
SELECT * from ' a ', ' B ' where ' a '. ' Bid ' like concat ('% ', ' B '. ' Bid ', '% ')

If you want to check that the A-table ID equals 1 corresponding data, you can write
SELECT * from ' a ', ' B ' where ' a '. ' id ' = ' 1 ' and ' a '. ' Bid ' like concat ('% ', ' B '. ' Bid ', '% ')
------Solution--------------------

CREATE temporary TABLE A (id int, bid varchar (TEN), Content varchar (10));
INSERT into a VALUES (' 1 ', ' 1,5,2 ', ' aaaaaaa ');
INSERT into a VALUES (' 2 ', ' 2,4 ', ' aaaaaaa ');
INSERT into a VALUES (' 3 ', ' 1,3,2 ', ' aaaaaaa ');
CREATE temporary TABLE B (bid int, content varchar (10));
INSERT into B VALUES (' 1 ', ' bbbbb ');
INSERT into B VALUES (' 2 ', ' bbbbb ');
INSERT into B VALUES (' 3 ', ' bbbbb ');
INSERT into B VALUES (' 4 ', ' bbbbb ');
INSERT into B VALUES (' 5 ', ' bbbbb ');
Select a.ID, b.bid as bid, A.content, b.content as Bcontent
From A, b
where Find_in_set (B.bid, A.bid)
ORDER BY a.ID

