[thelist] SQL Query Question

[rudy]

>  SELECT tblFOO.name, tblFOO.phone
>   FROM tblFOOR OUTER JOIN tblBAR
>    ON (tblFOO.phone = tblBAR.phone)
>  WHERE tblBAR.phone IS NULL
>
>  (something like that; not tested)

that's it exactly, eric

sorry i did not see this before firing off my reply in haste


<tip type="site architecture">
GOAL: URLs should be 'choppable', so that the result is a valid URL
PURPOSE: Given a URL like reviews/restaurants/cambridge.html many users
will look in the parent directories, hoping to find more restaurant reviews
at reviews/restaurants/, perhaps. This should be a valid URL.
Users, such as myself, only do this after giving up on the site's
navigation interface. This goal is relevant because in practice, you can
never guarantee that the web site interface design is perfect.
NOTES: Assuming that the restaurants directory really does contain more
restaurant reviews, which it probably should, then you have at least three
choices. You could let the user see a directory listing (naff), show the
user a 'no such page' or 'directory listing not allowed' error (unfriendly)
or show a restaurant reviews index page (nicest).
 --  from "Web site Architecture; Design guidelines intended to help create
a viable web site design in which Uniform Resource Locators (URLs) are
never changed" (http://hilton.org.uk/web_site_architecture.phtml)
</tip>

rudy