I'm working with two tables in a simple database. The data on each table contains partial data that together would comprise a completed record. I'd like to merge the two tables with a query and combine some of the fields to display in a single query. Let's say Table A [PhoneNum] and Table B [PhoneNum] fields exist. In order to display a complete record I need to combine [PhoneNum] from both tables into one in the query results.
Is this possible to do in a query? I believe the answer lies within SQL, but I have never touched SQL and am not sure how to implement.