Having multiple tables with same columns and retrieve data

[Antonio878]

I have two tables with two different names one will be called Windmill and one will be called runnergrl, now the both have the exact same columns in each table, but the only different is they have different information in each of there columns, I want to retrieve information from a column called name, which is in both tables, but I want to get any information in that column that is either named Windmill or runnergrl, so in the Windmill table I want to see if there is anything in each row under name that has the name runnergrl, and same goes for runnergrl to see if there is any name under name that is called Windmill.

Now I tried this:

"SELECT * FROM Windmill, runnergrl WHERE Windmill.name=runnergrl.name AND Windmill.name='runnergrl' OR runnergrl.name='Windmill'" 

but all its retrieving is Windmill's stuff from runnergrl's table but no runnergrl's stuff is getting retrieved under Windmill's table. Can someone help me find the reason why this is occurring. Also both tables have information from the other person so there is info under Windmill's table that belongs to runnergrl.

I keep trying different stuff to get both information but I keep just getting one and its stressing me out, please help me

[Antonio878]

Re: Having multiple tables with same columns and retrieve data

will anyone help me with this problem its like important for me =/