I have two tables tbl1 and tbl2.
I want to randomly select 10 rows from tbl1 which do not appear in tbl2.

NB:
I can do random selection from one table using:
Code:
SELECT * FROM tbl1
ORDER BY rand()
LIMIT 10;
Please assist on this.