Steve Grosz wrote:
This is a follow up message to a earlier threat this week (which is included
in the message below)
"model","CREATE TABLE `model` (
PRIMARY KEY (`PID`)
"vendor","CREATE TABLE `vendor` (
PRIMARY KEY (`PID`)
"specs","CREATE TABLE `specs` (
PRIMARY KEY (`SpecID`)
Like Rhi
Roger Baklund wrote:
[...]
You are joining the model table on vendor.PID=model.VendorID, and
model.VendorID is not a primary or unique key, it could contain
duplicates.
... probably the four rows you want. This is ok. It's probably the other
join that causes the problem.
--
Roger
--
MySQL Gene
This is a follow up message to a earlier threat this week (which is included
in the message below)
Ok, here's the model table:
"Table","Create Table"
"model","CREATE TABLE `model` (
`PID` tinyint(3) NOT NULL auto_increment,
`VendorID` tinyint(4) NOT NULL default '0',
`Model` varchar(15) NOT