i have problem using a msql code in getting a data from the mysql database by comparing two multi tables with the same field serve as our query to search them.could u help and send me a sample codes on it..
If you want to fetch data from two tables that have one column with the same data, like a record id, you can use the JOIN statement.
Check out the mysql manual about JOIN.
Or it is easier to do like this, assuming you want to join two tables with one column in common.
SELECT table1.,table2. FROM table1,table2 WHERE table1.CommonID=table2.CommonID
Correct Sam, that is MySQL's way of doing a JOIN without using the JOIN statement.
Is that specific to mySQL? I didn't know that.
