C++Bulder join two tables in SQL?

Question

SQL

I have such tables and they have such rows, I need to combine them in C ++ Bulder, for example, so that the rows of the "Transactions" table and the "Realtors" table would be displayed in one dbGrid, how is it better to do this in my case?
In the builder I do it through Connection, DataSet, DataSourse
Please tell me, otherwise I tried it through Join, and nothing came
of it, I need tables to be merged on the second grid

Answer 1

You can use View, which will display the results of a join table query.
something like...
SELECT * FROM Realtors
INNER JOIN Deals ON [Realtors].[Realtor ID] = [Deals].[Realtor ID]