Hi NG, this is my first visit here, so please be gentle!!!
I have a table of products (`prods`), and a separate table of product uses
(`uses`) and the products are linked to their uses by a list (`prod_uses`).
What I need to be able to do is allow a search of products by their use and
I am getting a bit stuck on writing the where clause. I know that for a
simple join I can use: SELECT * FROM table1, table2, WHERE
table1.field=table2.field2 AND table2.field2='value' - but how do I make a
join that will get back all products with a specified application?
Many thanks for your help and time...
regards,
Mikey
- In theory, theory and practice should be the same, in practice it isn't.
