>>Here is an example:

*-- Table1
*-- Strucutre:
FIELD1     FIELDX    FIELDY
2
4
2
2
1
4
4

*-- Table 2
*-- Structure
FIELD1     FIELD2    FIELD3
1               'ABC'      '123'
2               'XYZ'      '456'
3              'DFD'      '333'
4              'DDF'      '444'

*-- Resulting query should be
FIELD1     FIELD2     FIELD3
1               'ABC'      '123'
2               'XYZ'      '456'
4              'DDF'      '444'

>>
>>Now that I wrote the example, above, I think I can SELECT from Table2 and JOIN Table1 on FIELD1.


I think you do not even need a join for this, you can just select the records from Table2 that have a FK in Table 1, like:

SELECT Field1, Field2, Field3 FROM Table2 WHERE Field1 IN (SELECT Field1 FROM Table1)

As you are not using the FieldX and FieldY at all