I know this is basic but for some reason I struggle to figure it ou.
I want to create a query with all of our turnpike transponders with info r from a separate list of the trucks that have the transponders on them.
Back when I used Microsoft assess you built a query and selected Include all from the transponders table and only those from the units table that matched.
I’ve tried left join and right join but I’m not getting the expected results.
Does this require a repeat?