Hi,
Don't you miss some relationnal definition in your table.
Personnaly, I suggest in lnk :
Lnk: catid=int11 primary key
prodid=int 11
The key being (caid,prodid).
And simplier (Normal form) :
Categories: id=int 11 primary key
title = varchar
Products: id=int 11 primary key
name=varchar
catid int 11
The query will then be evident.
Mathias
-----Original Message-----
From: Andy Pieters [mailto:[EMAIL PROTECTED]
Sent: dimanche 24 avril 2005 19:35
To: mysql@lists.mysql.com
Subject: Multi condition/table select
Hi all
I am trying to figure out how to do this in one query.
Using MySQL 2.3.58
Tables (only relevant data shown)
Categories: id=int 11 primary key
title = varchar
Products: id=int 11 primary key
name=varchar
Lnk: catid=int11 primary key
lnk=int 11 (key: unique combo catid+lnk)
Id's for categories are between 20001 and 25000
id's for products are <20000
I want to select all products that do not have a link to category x in
the
table Lnk.
Example
Categories:
id title
20001 Network
20002 Switches
Products
id name
1 10/100 Switch 5 port
2 10/100 Switch 8 port
3 10/100/1000 Switch 5 port
Lnk
catid lnk
20001 20002
20002 1
With this data, when using the category 20002, the query should return
products with id 2, and 3. If used with category 20001, it should
return
products with id 1, 2, and 3
I was thinking on using three left joins but have been unable to make
working
code.
Can anybody make sense to this?
With kind regards
Andy
--
Registered Linux User Number 379093
--
Check out these few php utilities that I released
under the GPL2 and that are meant for use with a
php cli binary:
http://www.vlaamse-kern.com/sas/
--
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
