I am new to SQL and am having trouble constructing an SQL Query.
Basically I have a database consisting of 3 tables, one called ILLNESS, one called PRODUCTS and one called PRODUCTLINK.
The PRODUCTLINK table contains an id linking to an illness and an id linking to a product.
I want a user to be able to enter the symptoms they have and for the database to return the illness they are suffering from and the products that will help them.
Can anyone help me with the query?