I have this query that gives me back rows with two columns each containing an id.
SELECT idEng, idDutch
FROM phraseConnections
WHERE cat = '3'
the id's are from other tables where they are connected to a phrase i want to get.
I tried something like this.
SELECT a.phrase, b.phrase
FROM phraseEnglish as a, phraseDutch as b
WHERE a.id = (SELECT idEng
FROM phraseConnections
WHERE cat = '3')
and b.id = (SELECT idDutch
FROM phraseConnections
WHERE cat = '3')
thanks.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…