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.