I have two exactly the same tables (layout, columns, data everything is the same) and when i do a query on table 1 like : SELECT j01.* FROM j01 WHERE j01.CAMPAGNE = 'HEYTENS' ORDER BY j01.FIN i get 7 results (that's ok cos' there are 7 rows in the campagne column who have the value HEYTENS, if i do the same query for the 2nd table i also got 7 results, but if i do the following SELECT j01.* FROM j01, j02 WHERE j01.CAMPAGNE = 'HEYTENS' AND j01.CAMPAGNE = j02.CAMPAGNE ORDER BY j01.FIN I get 49 results. Is this normal ? I only want to have exactly the same rows from both tables I'm using these queries in php and the opening of the database connection are ok .... If anyone knows some solution, I'll be glad to hear it - or i'm i making some big fault in my thinking ?
