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.
