SQL Select with blank linked tables

[Ruslan Zasukhin]

on 11/3/03 0:33, Ian Devaney at idevaney at mac.com wrote:

> I have several tables linked by objectPointers and am trying to create
> a standard SQL search query.
> 
>  s = "SELECT "
>  s = s + "people.*, "
>  s = s + "gifts.*, "
>  s = s + "stores.*, "
>  s = s + "events.*, "
>  s = s + "links.*, "
>  s = s + "FROM people, gifts, stores, events, links"
> 
> When there ARE entries in the gifts table - for example - which are
> linked to a person in the people table then this works fine.
> 
> What is the correct syntax to still find the "people" records if they
> don't have any "gifts" or if the "gifts" don't have any "stores" etc.
> etc. ?
> 
> I presume I should be able to do this with some kind of join but can't
> seem to get anything to work.

I think you need outer join again, Ian

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------