From: Peter Brawley
Date: March 18 2006 3:05pm
Subject: Re: select from multiple tables
List-Archive: http://lists.mysql.com/mysql/195941
Message-Id: <441C21B8.5020505@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Miguel

 >   What i need is to list all the products and show the type name of 
each of them.

What you need is a join 
(http://dev.mysql.com/doc/refman/5.0/en/join.html), eg:

SELECT t.id, t.id_type, t.name, t.desc, t.price, p.name
FROM tbl AS t
INNER JOIN products AS p USING (id)

PB

-----

Miguel Vaz wrote:
>
>     Hi guys,
>
>     I am kinda new to mysql and on my endeavour to build a backend for 
> a site i am building, i need to fetch data from a couple of tables, 
> but dont know how to do it with a single select.
>     Heres the problem:
>
>     first table (products):
>
>     id
>     id_type
>     name
>     desc
>     price
>
>     second table (types):
>
>     id_types
>     name
>
>
>     What i need is to list all the products and show the type name of 
> each of them. On the products table, on the "id_type" field, i have 
> only a number pointing to its type on the "types" column, what i want 
> to know is how i can do a select to fetch all the product records and 
> replace the number on "id_type" with its equivalente name from the 
> "types" table.
>
>     Sorry if i cant explain it correctly, but heres an example:
>
>     table products:
>
>     id    id_type    name    desc    price
>     1    2    prod1    blah    45
>
>     table types:
>
>     id_type        name
>     1        razor
>     2        string
>
>     I want the list to show:
>
>     prod1    string    blah    45
>
>
>     Thanks,
>
>     Miguel
>
>