Find Jobs
Hire Freelancers

MS SQL QRY over 3 Tables

$5-10 USD

Completed
Posted almost 15 years ago

$5-10 USD

Paid on delivery
Hi, i need a sql qry wich qry over 3 tables. Thing is, this should be a website abaout cocktails. So i have about 50 checkboxes with different kinds of ingredients (e.g. Rum, Vodka etc) So the user can click what they like to use for there Cocktails. So now if the user Checks Rum, Cola and lemon the qry will return "yeah so you got Rum, Cola and lemon . Try a Cuba libre" Because it contains exactly Rum, Cola and lemon. Now the user selects Rum and Cola - The script WONT return cuba libre, because you need also lemon for that. Now the user selects Rum, Vodka, Cola, lemon - The script WILL return cuba libre, because you can do it with the selected ingedients. I will add a .sql file with Database and a Screenshot form ServerBrowser (So you can look at it bevor using the .sql) It has to be done in C# 2005 (.net 2.0) and MS SQL 2005 Thanks a lot Martin
Project ID: 3950522

About the project

9 proposals
Remote project
Active 15 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$5 USD in 2 days
5.0 (1 review)
0.0
0.0
9 freelancers are bidding on average $7 USD for this job
User Avatar
See private message.
$8.50 USD in 2 days
4.7 (61 reviews)
6.0
6.0
User Avatar
See private message.
$8.50 USD in 2 days
5.0 (96 reviews)
5.9
5.9
User Avatar
See private message.
$8.50 USD in 2 days
4.5 (100 reviews)
5.4
5.4
User Avatar
See private message.
$6.80 USD in 2 days
4.7 (47 reviews)
5.2
5.2
User Avatar
See private message.
$5.95 USD in 2 days
5.0 (2 reviews)
1.3
1.3
User Avatar
See private message.
$8.50 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$3.40 USD in 2 days
0.0 (0 reviews)
0.7
0.7
User Avatar
See private message.
$8.50 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Germany
5.0
5
Member since Oct 27, 2002

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.