On Fri, 30 Jan 2004, Mitch Patenaude wrote:
> select distinct O.OID, O.Name, O.Acronym
>from Organizations O, OrgDocs D, OrgProjects P
> where D.OrgID = O.OID or P.OrgID = O.OID
>
> I think this will result in two full table scans though..
Actually, it will probably result in Count(
ahh, I just got this to work. Here's the query I used (MySQL 3.x)
select distinct Organizations.OID , Organizations.Name ,
Organizations.Acronym
from OrgDocs , OrgProjects , Organizations
where (OrgDocs.OrgID = Organizations.OID) or (OrgProjects.OrgID =
Organizations.OID)
still interested in o
select distinct O.OID, O.Name, O.Acronym
from Organizations O, OrgDocs D, OrgProjects P
where D.OrgID = O.OID or P.OrgID = O.OID
I think this will result in two full table scans though..
-- Mitch
On Friday, Jan 30, 2004, at 21:24 US/Pacific, David Siedband wrote:
I have two index tab
I have two index tables the associate Organizations with documents and
projects. I'm trying to write a query that returns all the
organizations that are associated with either a project or document.
To select distinct organization that are either associated with a
Document or a Project, I'm us
On Fri, 30 Jan 2004, Ken Bloom wrote:
> I find my self frequently sshing from a MacOS X box to my Debian box
> using the built-in terminal and ssh applications. When I do this, it's
> usually to check my email using mutt or compose email using mutt or
> vim.
>
> Here's my problem - the arrow keys
Perhaps take a look at http://macvim.swdev.org/OSX/ and search for
"termcap". I remember installing a new termcap from somewhere when I
was running 10.1, but I don't remember why, or where I found it.
Googling "OS X termcap" might uncover something. I don't use vim, so
that's all I've got to
I have a backup script that I run periodically (and I haven't run it
in two whole weeks), and I was trying to run it today but since having
switched to devfs, the permissions on the cd drive's device file seem
to have changed (probably as a result of the switch), so that I can't
read the file syste
I find my self frequently sshing from a MacOS X box to my Debian box
using the built-in terminal and ssh applications. When I do this, it's
usually to check my email using mutt or compose email using mutt or
vim.
Here's my problem - the arrow keys don't work, and I don't get color
either (Instead,
on Thu, Jan 29, 2004 at 03:49:10PM -0800, Henry House ([EMAIL PROTECTED]) wrote:
> P? torsdag, 29 januari 2004, skrev Karsten M. Self:
> [...]
> > : *after* '0' indicates a lockfile. Any rule that writes to a file
> > _should_ use a lockfile. Rules which invoke a program '| command'
> > o