Repetitive Records

Hello! i have created three tables and inserted different records in them. I want only "genes" records from table 1,2 and 3 to be shown. The problem I am having is that when I design the query and ran it, it shows me all the possible combinations of records instead of showing only 1 record.

Table 1 - Number - Population - Genes
Table 2 - Number - Genes
Table 3 - Number - Genes

Table 1 - Records
==============
Number 1 - India - AB48
Number 1 - Pakistan - AB35
Number 1 - South korea - AB48

Table 2 - Records
=============
Number 1 - BD34
Number 1 - GF45

Table 3 - Records
=============
Number 1 - HG65
Number 1 - LK98

SQL
=====
SELECT Table1.Number, Table1.Population, Table1.genes AS Table1_genes, Table2.genes AS Table2_genes, Table3.genes AS Table3_genes
FROM Table3, Table2, Table1;

Now the question is that either I need to use Criteria or Filter to show the each record from the table. The problem I am having is that when I run this query it shows me all the possible combinations of each record from the table.

I want to show only the records which are in those fields and nothing more or less.

Could you please help.

SIZE="1"][Please note: The database I have shown here is an example and does not reflect my personal database however I have made an example to show what i am trying to achieve here][/SIZE]

Many Thanks

Jay