SQL querry with parameter

  • Thread starter Thread starter Jacques2
  • Start date Start date
J

Jacques2

Guest
For example, I have three tables: customers (#c, customer), products (#p, product) and sales (#s, product, customer). What SQL (or more precisely, SELECT) statement should I use to get a querry with a parameter? What I mean is that when I run the querry it must ask me for the parameter to be the name of the product (or better, part of the name using, for example, LIKE). The result should consist of all the sales that contain the given parameter (the product). Thank you a lot for the help!
 

Users who are viewing this thread

Back
Top Bottom