How to write an SQL statement that queries the corresponding values of all Id fields in one table in another table?

Loading editor...

How to write an SQL statement that queries the corresponding values of all Id fields in one table in another table?
Multi-table join query:
Select RBD. rbdid, RBD. productcode, P. productcnname, P. [standard], p. impression, PB. BrandName, cgdw. unitname, UN. unitname
, RBD. buyingamount, RBD. unitprice
From pcs_requestbuydetails as RBD
Left join pm_products as P on RBD. productcode = P. productcode
Left join cons_productbrands as Pb on p. brandid = Pb. brandid
Left join cons_units as cgdw on RBD. buyingunit = cgdw. unitid
Left join cons_units as UN on RBD. stockunit = UN. unitid
Where RBD. rbid = 7
Another method:
Subquery
Select (Select name from Ta where id = Tb. id1) as id1,
(Select name from Ta where id = Tb. Id2) as Id2
From TB