Na primjer:
Code:
CREATE TABLE tvoja_tabela (
id INT UNSIGNED NOT NULL ,
PRIMARY KEY (id)
) ENGINE=InnoDB;
CREATE TABLE brojevi (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
id_tvoja_tabela INT UNSIGNED NOT NULL,
broj INT UNSIGNED NOT NULL,
PRIMARY KEY (id),
KEY tvoja_tabela_fk (id_tvoja_tabela),
CONSTRAINT tvoja_tabela_fk FOREIGN KEY (id_tvoja_tabela) REFERENCES tvoja_tabela (id) ON UPDATE CASCADE ON DELETE RESTRICT
)ENGINE=InnoDB;
SELECT b.id_tvoja_tabela, b.broj
FROM tvoja_tabela t, brojevi b
WHERE t.id=b.id_tvoja_tabela
AND t.id=1
ORDER BY RAND() LIMIT 6;