Given this scenario:
Imagine a scenario in the field of oceanography, where table_A, in addition to the primary key, also needs to keep the direction of the wind (wind direction) and the direction of the wave (dir_condulation). Knowing that the table_ventos (id_vento, desc_vento) has all the possible directions, and both the fields dir_vento and dir_ondulacao are also winds, it would be possible that they stored the id_vento, in the future I will rescue the dsc_vento of the table wind from them, would be the fields dir_vento and dir_ondulacao foreign keys of the table_ventos.
How do I run select?