THE FIRST 3 RECORD ON THE TABLE, BUT I THINK WHAT HAPPENS HERE IS THAT THERE ARE ONLY 3 RECORDS IN TABLE 2 AND IT ONLY LIKED THEM WITH TABLE1 WHICH HAS 20 RECORDS.
THAT´S VERY POSSIBLE.
MY REAL SCENARIO IS THIS.
I HAVE ON TABLE1 SEVERAL RECORDS(CHURCHES), IT MAY GO TO HUNDREDS PERHAPS AND THEN ONLY A FEW ON TABLE2, WITH ARE(PASTORS) AND WHEN I JOIN THEM i WANT TO BE ABLE TO SHOW CHURCHES WITH IT´S PASTORS NAME AND PHOTO ALONG WITH THE CHURCHES INFORMATION, THEN IF THE CLIENT WANTS TO SEE MORE OF PASTOR INFORMATION, I WANT TO LINK IT TO PASTOR´S PROFILE AND SHOW ALL OF IT´S INFORMATION, BY PASSING PARAMETES FROM ONE PAGE TO ANOTHER.
THANKS AGAIN.