AnsweredAssumed Answered

Selection Across related tables

Question asked by dwin on Jul 27, 2013
Latest reply on Jul 28, 2013 by GuyStevens


Selection Across related tables


     I am trying to do a find across tables - here would be a simple example of what I would be trying to do. 

     A database that has two tables - one for individuals and their addresses and phone numbers, and another one with the transactions (date purchased, product). These are connected by a unique ID assigned to the individual and is used when creating the transaction purchase. 

     I want to find those people who live in Ohio and purchased a sweater. Additionally I want to show what city/town they live in and the date of the purchase.

     So the idea is to select on a single field in two two different tables and show a couple of fields from each of the two tables.