Traditional I would use a JOIN statement to connect two tables together. I’m trying to figure out how to join two tables using custom tables. Let’s say for example I have two table’s contacts and phone numbers with the following structure.

Contacts (contact Id, first name, last name)
PhoneNumbers (phone Id, contact id, Phone type, phone number)

Traditionally I would have created a sql statement like

SELECT * FROM Contacts
JOIN PhoneNumbers ON Contacts.contactid = PhoneNumbers.ContactId

How do I do something similar with custom tables?