Re: How to solve this problem?

2006-05-09 Thread Barry
彭一凡 schrieb: Hi There is a schema example below: (From A first course in database system) Product (maker, model,type) Pc (model, speed, ram, hd, rd, price) Laptop (model, speed, ram, hd, screen, price) Printer (model, color, type, price) The statement below seems wrong based on MySQL

Re: How to solve this problem?

2006-05-09 Thread Johan Lundqvist
First I would advice you to take a closer look at: http://dev.mysql.com/doc/refman/5.0/en/join.html It will answer your question. /Johan ??? wrote: Hi There is a schema example below: (From A first course in database system) Product (maker, model,type) Pc (model, speed, ram, hd, rd, price)

how to solve NOT problem?

2001-09-15 Thread Libor Maty
hi, i'm having the following problem that sort of makes my life miserable :-) i've been working on a search script that could take a query like this: (car and bus) or apple not (orange and table)etc. ...basicly any logical statement...and return the right references based on searching

Re: how to solve NOT problem?

2001-09-15 Thread Lezz Giles
01 5:25 AM Subject: how to solve NOT problem? hi, i'm having the following problem that sort of makes my life miserable :-) i've been working on a search script that could take a query like this: (car and bus) or apple not (orange and table)etc. ...basicly any logical statement...