just a small problem if you can help me

• d.m.amine

  Old Hand

  Points: 312

  More actions

  April 12, 2010 at 8:32 am

  #217738

  hello everyone:

  I have a problem at a requet

  I want it displayed the same brand product

  for example

  given DB is like this:

  product_id | brand

  -----------------------------

  P1 | 300

  P2 | 300

  P3 | 300

  P4 | 300

  IPS | ME10

  ST | ME15

  So I want to show that P1, P2, P3, P4 when I click on Product P1

• ps.

  One Orange Chip

  Points: 29422

  More actions

  April 12, 2010 at 8:51 am

  #1150106

  d.m.amine (4/12/2010)

  ---

  hello everyone:

  I have a problem at a requet

  I want it displayed the same brand product

  for example

  given DB is like this:

  product_id | brand

  -----------------------------

  P1 | 300

  P2 | 300

  P3 | 300

  P4 | 300

  IPS | ME10

  ST | ME15

  So I want to show that P1, P2, P3, P4 when I click on Product P1

  select product_id from myTable where brand IN (select brand from myTable where product_id='P1')

  Is that what you want? I guess thats a simple sub query..

  ---

  
  Pradeep Singh

• d.m.amine

  Old Hand

  Points: 312

  More actions

  April 12, 2010 at 8:56 am

  #1150111

  thanks again thk you very much

  your answer is very good

  thx my friend