VB is not a Relational Database Management System (RDBMS).
The joining of fileds, or the presenting of a calculation as a field, would be a function to the RDBMS (Oracle, SQL Server, etc.)
If the RDBMS will support it, then if you put it into the SQL you run against the RDBMS will return the desired resluts.