SQL query returns value duplicates and with error

Question

SQL query returns value duplicates and with error

Navigation

#1 by (1 votes)

0

I have the following query but it is returning duplicate and erroneous results. Arthur should appear 0 instead of 30.

sql

asked by anonymous 03.12.2017 / 12:20

1 answer

Doubt - Design on the secondary screen and Form Clear only one line from a batch file

score 1 · Answer 1

I've come to the conclusion of how it does:

SELECT Player_name, Subscription_id,Date_subscription,Amount_paid,Attendance_id,Training_date
FROM PLAYER p,SUBSCRIPTION s, Attendance a
WHERE p.SUBSCRIPTION_SUBSCRIPTION_ID = s.SUBSCRIPTION_ID and a.PLAYER_PLAYER_ID = p.PLAYER_ID;