A Visual Explanation of SQL Joins SELECT * FROM tablename WHERE somefield='something' ORDER BY RAND() LIMIT 5 CREATE TABLE employee_records2 (name VARCHAR(50), employeeID INT) CREATE INDEX id_index ON employee_records2(employeeID) SELECT r.id, r.weight, r.des, GROUP_CONCAT(b,id FROM Rule r , B b Where r.id = b.id GROUP BY r.id |