26 AM, Paracková Eva, Ing wrote:
peopleID should match:
SELECT lastname, model FROM people, machines WHERE machines.peopleID =
people.peopleID;
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 2. júna 2003 9:19
To: [EMAIL PROTECTED]
Subject: my first select
I m
peopleID should match:
SELECT lastname, model FROM people, machines WHERE machines.peopleID =
people.peopleID;
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 2. júna 2003 9:19
To: [EMAIL PROTECTED]
Subject: my first select
I made a small DB of people and
I made a small DB of people and machines, where one person can have
more than one machine, each machine can be assigned to only one person.
people | machines, one-to-many.
I have a primary key ID field in each table (peopleID, machineID) and
in the machines table I have the peopleID, the foreig
