select * from cricket as c inner join football as f on c.name =f.name; select c.cricket_id ,c.name ,f.football_id,f.name from cricket as c inner join football as f on ...