Selecting rows from 2 tables

[Anon]

I have 2 tables, one called matches, and one called dummymatches.
The dummymatches contains team1, team2 and division. Matches contains those columns and others like time, place etc. 'dummymatches' is for the benefit of the match generator.

I want to return rows from both tables for a while loop. I was thinking something like this:

SELECT * FROM matches, dummymatches WHERE matches.division='$div' OR dummymatches.division='$div';

But that doesn't work. Also:

SELECT * FROM dummymatches STRAIGHT_JOIN matches WHERE matches.division='$div' OR dummymatches.division='$div'

Doesn't work.

I've looked through all the JOIN syntaxes in the MySQL manual but I can't find what I'm looking for. All I find is infomation on how to join tables on matching fields between the 2 tables.

Thanks for any help in advance.

[Anon]

Uou may care to look up union in the documentation.

select team1, team2, division
from matches
union all
select team1, team2, division
from dummymatches