|
Re: SQL solution needed - urgent! [message #610216 is a reply to message #610215] |
Tue, 18 March 2014 09:39 |
cookiemonster
Messages: 13917 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Please read and follow How to use [code] tags and make your code easier to read?
Assuming your using oracle you'll only get an error from that, you can't us AS in the from clause.
If you join a record in one table to two records in another table your resulting output will be two records.
You need to either:
a) use an IN/EXISTS sub-query to check the balls table
b) use DISTINCT to eliminate the duplicates.
(a) is generally considered to be the better practice.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|