SQL Programming ?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • william77
    New Member
    • Feb 2015
    • 2
    #1

    SQL Programming ?

    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.




    Tags: None
    • Rabbit
      Recognized Expert MVP
      • Jan 2007
      • 12517
      #2
      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.

        Comment

        • william77
          New Member
          • Feb 2015
          • 2
          #3
          Can you give me any suggestions on how I can get around this?

            Comment

            • Rabbit
              Recognized Expert MVP
              • Jan 2007
              • 12517
              #4
              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.

                Comment

                Previous template Next
                Working...