[RESOLVED] phpMyAdmin query issue

[netfrugal]

I am getting weird results from running queries, and maybe my syntax is wrong, but I don't think so.

I place this simple query:

SELECT * FROM table1

I get the right amount of rows

But, if I add multiple tables to it:

SELECT a.*, b.* FROM table1 a, table2 b

I get millions of rows and duplicates back! Is it phpmyadmin making this mistake? Is it the database? or is it my query?
This has happened before in the past, but seemed to right itself.

Any thoughts?

[netfrugal]

Nevermind, I forgot to apply the matching columns

Ooooooooopppppsssss