Re: New to SQL and trying multiple table joins

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 20:47:14 +0100

I think you will need to convert some of your INNER joins to OUTER joins.
That should capture both those who do and don't have a job. Can't be certain
of how to write this query for you without DDL (CREATE TABLE statements) for
all these tables and maybe some sample data as well. At minimum we really
need to know what the Primary and Foreign keys are. 

-- 
David Portas
SQL Server MVP
--

Relevant Pages

  • Re: Best way to use INNER JOIN?
    ... I've always used this form of inner joins - ... differentiate join condition vs where condition for outer joins see ... Speaking of natural join synatx - yea, ... select bs.Title from BOOKSHELF bs inner join BOOK_ORDER bo ON bs.title ...
    (comp.databases.oracle.server)
  • 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: 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, ...
    (comp.databases.ms-access)
  • Re: Joins over the equality sign
    ... I prefer "ANSI joins" for inner joins. ... Outer joins: ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: speed up query
    ... Mike Epprecht, Microsoft SQL Server MVP ... Blog: http://www.msmvps.com/epprecht/ ... "JJFreds" wrote in message ... > i 've one quey joining with 4 inner joins and and one left join ...
    (microsoft.public.sqlserver.programming)