Concatanate from 2 tables

Hello,
Is it possible to concatenate data from two tables? For example, I would like to take the label column from the llx_product table and two extrafield columns from the llx_product_extrafield table. Ultimately, I want to display these columns in one extrafield in the dropdown with the label serial number and date.