select * from table_name where product like 'p1' order by price limit 1;
----- Original Message -----
From: "Ciprian Trofin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 28, 2002 11:20 AM
Subject: Join or smth.
> I have a table that looks smth. like this:
>
> id product price store
> --------------------------
> 1 p1 100 s1
> 2 p1 120 s2
> 3 p1 100 s3
> 4 p2 120 s1
> 5 p2 95 s2
> 6 p2 300 s3
> 7 p3 100 s1
> 8 p3 120 s2
> 9 p3 125 s3
> 10 p3 130 s1
>
> CREATE TABLE `products` (
> `id` tinyint(3) unsigned NOT NULL auto_increment,
> `product` varchar(4) NOT NULL default '0',
> `price` smallint(3) unsigned NOT NULL default '0',
> `store` varchar(4) NOT NULL default '0',
> PRIMARY KEY (`id`)
> ) TYPE=MyISAM;
>
> #
> # Dumping data for table 'products'
> #
>
> INSERT INTO products VALUES("1","p1","100","s1");
> INSERT INTO products VALUES("2","p1","120","s2");
> INSERT INTO products VALUES("3","p1","110","s3");
> INSERT INTO products VALUES("4","p2","120","s1");
> INSERT INTO products VALUES("5","p2","95","s2");
> INSERT INTO products VALUES("6","p2","300","s3");
> INSERT INTO products VALUES("7","p3","100","s1");
> INSERT INTO products VALUES("8","p3","120","s2");
> INSERT INTO products VALUES("9","p3","125","s3");
> INSERT INTO products VALUES("10","p3","130","s1");
>
>
> I want to build a query to find out where I can find the least expensive
> product.
>
> I know how to solve the problem using a script language (PHP) but I'd like
> to do it SQL-style :). I guess it can be done using some sort of JOIN.
>
>
> --
> Ciprian
>
> > Always smile. It makes people wonder what you're up to.
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
