Find records matching another table
First of all, I'm on day two of my FM experience, sorry this is probably quite basic, but after two hours of trying and searching I give up. I'm an SQL and Panorama guy, until now.
My main table contains billing records, the key field being the invoice number. My second table contains a set of invoice numbers. How do I find the records in the billing table that match the invoice numbers in the second table?