MySQL: Limited Join?

[rapante]

Ich weiss nicht ob ich deine Anforderung richtig verstanden habe. Wie ist es denn hiermit?:

Code:

SELECT tableA.x, 
       (SELECT tableB.y FROM tableB ORDER BY rand() LIMIT 1) AS erg1,
       (SELECT tableB.y FROM tableB ORDER BY rand() LIMIT 1) AS erg2,
       (SELECT tableB.y FROM tableB ORDER BY rand() LIMIT 1) AS erg3,
       (SELECT tableB.y FROM tableB ORDER BY rand() LIMIT 1) AS erg4,
       (SELECT tableB.y FROM tableB ORDER BY rand() LIMIT 1) AS erg5
FROM tableA