field name = custtype_abbr
table =ref_customer_type
join id = customertype_id

SELECT custtype_abbr FROM ref_customer_type WHERE customertype_id=target.[@field:customertype_id]
SELECT street_address FROM customer_address_tbl
 WHERE cust_rid=target.[@field:cust_rid]