The problem is I have a table that need the description of the other table with two fields:

Table 1 with field
Field1
Field2

Table 2 with field
Code
Description


Ex:

The table 1 has a record
Field1 Field2
'001' '004'
'002' '001'

The table 2 has a record
Code Description
'001' 'Sample 1'
'002' 'Sample 2'
'003' 'Sample 3'
'004' 'Sample 4'

I need to get a SQL statement like this:
Field1Code Field1Description Field2Code Field2Description
'001' 'Sample 1' '004' 'Sample 4'
'002' 'Sample 2' '001' 'Sample 1'


I hope someone can help me with this.