I have a question about how joining works in the sql explorer of db connect.
I have 2 tables one with database information and another one with Hardware information.
The database table includes: DB_OBSO_SGBD_DATE, DB_T_ENVIRONMENT, DB_T_NAME, DB_T_SGBD_CATEGORY, DB_T_SGBD_RELEASE, HRD_T_NAME.
And the interesting fields for me from the Hardware table are HRD_T_NAME and HRD_C_SECTOR.
In the Hardware table, there are more items in HRD_T_NAMES, than in the database table.
I now want to join these two tables together to get the matching HRD_T_Names and the HRD_C_SECTOR in one table.
Has someone suggestions for the join function?
Thx in advance.