SoftwareDatabase help SQLPosted:

Status: Offline
Joined: Apr 05, 20162 Year Member
Posts: 18
Reputation Power: 0
I need some database help anyone any good at it

im running a SELECT JOIN and it keeps returning more than it should
#2. Posted:
Scizor
  • Moderator
Status: Online
Joined: May 23, 20117 Year Member
Posts: 2,058
Reputation Power: 1840
Motto: Ayo
What's the script/code you're running?

you can use the [code] tag for inserting code in an easy to read form.
#3. Posted:
Status: Offline
Joined: Apr 05, 20162 Year Member
Posts: 18
Reputation Power: 0
SELECT DISTINCT ORDERS.order_id, ORDERS.order_date, ORDERS.specialty_notes,PRODUCTS.product_id, PRODUCTS.product_name,
PRODUCTS.product_description, PRODUCTS.unit_price,QUANTITY.quantity, GUESTS.guest_id, GUESTS.last_name, GUESTS.first_name,
GUESTS.middle_initial, GUESTS.street_address,GUESTS.apt, GUESTS.home_phone, GUESTS.cell_phone,GUESTS.email
  FROM ORDERS
  JOIN GUESTS ON ORDERS.guest_id
  JOIN QUANTITY ON ORDERS.order_id
  JOIN PRODUCTS ON QUANTITY.product_id
 
#4. Posted:
Status: Offline
Joined: Apr 05, 20162 Year Member
Posts: 18
Reputation Power: 0
i can't post my schema because the TECH game wont let me post the rest of the code
#5. Posted:
Scizor
  • Moderator
Status: Online
Joined: May 23, 20117 Year Member
Posts: 2,058
Reputation Power: 1840
Motto: Ayo
I'm guessing this is just in a test database for learning right?

Can you post the output of your script?
Users browsing this topic: None
Jump to:


RECENT POSTS

HOT TOPICS