By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,686 Members | 1,903 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,686 IT Pros & Developers. It's quick & easy.

SQL Programming ?

P: 2
Below is a screenshot of my sql code and results where I've been trying to join 3 tables. I need to find the number and name of each customer that currently has an order on file for a Gas Range. I've included screenshots of the data as well. Any help you can give me with this most difficult problem will be appreciated.




Feb 21 '15 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,430
You're filtering for where the customer number is equal to the part number. That doesn't make any sense, especially since one is numeric and the other is a string.
Feb 22 '15 #2

P: 2
Can you give me any suggestions on how I can get around this?
Feb 22 '15 #3

Rabbit
Expert Mod 10K+
P: 12,430
You have to join on the correct field. I can't tell you what that is. None of the fields you currently have look correct for a join to the parts table.
Feb 22 '15 #4

Post your reply

Sign in to post your reply or Sign up for a free account.