Re: Linked tables in a query giving no results

change the joins between Projects and the other tables from inner joins
to outer joins. Open the query in design view, click on the join line,
and change the join type.

.

Relevant Pages

  • RE: Difference in Query Result Using Left Outer Join
    ... > Only with LEFT OUTER and RIGHT OUTER joins do you see this behaviour. ... > INNER JOINS, you get exactly the same result when using a AND or WHERE. ... > If you were to run the 2 queries in Query Analyzer with Display Execution ...
    (microsoft.public.sqlserver.programming)
  • Re: Problem w/ # of records returned when joining 2 queries
    ... join property #3, the # of records that I was trying return for my specific ... The problem query uses inner joins. ... Inner joins return only the results that match. ... The solution will be to use outer joins in the query. ...
    (microsoft.public.access.queries)
  • RE: Query not Returning Results
    ... Changing all INNER Joins to OUTER joins but when run a Synax Error was ... When i come to running the query i simply get no results returned? ...
    (microsoft.public.access.queries)
  • Re: Cant double click joins in VFP8 view designer
    ... or does the view designer still blow chunks? ... mixes left inner joins with left outer joins. ... I can create it in the query designer and run ...
    (microsoft.public.fox.programmer.exchange)
  • RE: Multiply qty of filtered records
    ... If you should want to try doing this with a query (which is probably the more ... etc in the bottom part of the design view. ... I do know how to get this information in a Report, ... Dim rs As DAO.Recordset ...
    (microsoft.public.access.modulesdaovba)