how to get the data from table with join

I'm created two table first one is test1 and second one is test2.
In first table one field is id and in second table one field is id.
in first table two data/value insert 1 and 2 and second table four data/value insert 1, 2, 3 and 4

I want to acess only 3 and 4 data with use join key

how can do this???????????
plz help me.....................

 

What is the relationship between the tables? Is the ID field the fkey you are using?

If so, then this should be what you are after - you will have to substitute the relevant parts/names since you do not give full details;

SELECT two.column3, two.column4 from tableone as one inner join tabletwo as two ON (two.id = one.id)

Code (markup):

 

I will try............