abase Administrator
Unimin Corporation - Spruce Pine
Laszlo Thoth <[EMAIL PROTECTED]> wrote on 10/01/2004 11:53:23 AM:
> I'm having difficulty constructing a query. I've got two kinds of
> information:
> a table of resources that various people have, and a table of reso
et (0.00 sec)
-Original Message-
From: Laszlo Thoth [mailto:[EMAIL PROTECTED]
Sent: Friday, October 01, 2004 10:53 AM
To: [EMAIL PROTECTED]
Subject: matching people with projects via resources
I'm having difficulty constructing a query. I've got two kinds of
information:
a table
[snip]
You haven't stated the resources required for the project in the query.
Try this ...
SELECT project.proj, project.rsrc, people.name
FROM project LEFT JOIN
people ON project.rsrc=people.rsrc
WHERE project.rsrc = 'wood'
AND project.rsrc = 'canvas'
Not tested, but limits people to thos who h
a table of resources that various people have, and a table of resources that
various projects need.
===
CREATE TABLE `people` (
`name` varchar(11) default NULL,
`rsrc` varchar(15) default NULL
);
INSERT INTO `people` VALUES
('noah','w
[snip]
I'm pretty sure this is a good starting point, but that's just matching
resource
to resource without excluding Lincoln from building an Ark (no canvas).
mysql> SELECT project.proj,project.rsrc,people.name FROM project LEFT
JOIN
people ON project.rsrc=people.rsrc;
+--+-+-
I'm having difficulty constructing a query. I've got two kinds of information:
a table of resources that various people have, and a table of resources that
various projects need.
===
CREATE TABLE `people` (
`name` varchar(11) de
Hi,
I have two tables in my database. One that holds information on bookings on
varous projects for a scheduling system, and the other holds project
informtaion.
Is it possible to produce a report that lists total bookings by project a
month with one query i.e.
Jan Feb Mar Apr
Hi friends,
Can anybody tell me some good projects in C/C++/ with
MYSQL with brief explanation. Focus is on MYSQL.
Thanks in advance.
regards...
-krishna
Email: [EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http
Dear team,
Welcome to the mysql mailing list,
ithis is my first mail to the list. i am a perl developer with mysql as
backend.
You can give me projects of perl with mysql as backend.
naveed
-
Before posting, please check
