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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
