Query question using 2 tables !

[johnr715]

I'm trying to build a query combining the 2 following tables :

Table a:

Name # Sales
John 5
Bill 4
Dan 3

Table b:

John 3
Bill 6

The query retur was :

Name # Sales
John 8
Bill 10

I lost Dan's data because it wasn't in both tables.

Is there a way to get Dan's results in this query even though he's not in both tables?

Thanks

 

[Joe4]

In your query, change the link/relationship between the two tables to "Select All Records from TableA and only those from TableB that match." It will look like an arrow going from TableA to TableB.

 

[johnr715]

:wink: Many thanks!!