Pardon me,
It should have read Player not Name in table 1. I don't get an error I get
ID | Name | Player | goals | assists | shutouts | points
--
1 rob J.Doe 2 3
It doesn't explain the problem at all, since you didn't say what the
problem was..
I would have expected an error message because:
You can't join USING (player) because 'Players' has no 'player', and if
it did, the WHERE
clause would be redundant. The WHERE clause also references the
non-exis
Hi,
query question:
I have 2 tables created using Mysql:
1) Players
Name(varchar),Team(varchar),Goals(tinyint),Assists(tinyint),Shutouts(tinyint),points(int).
2)draftees
ID(smallint),Name(varchar),Phone(varchar),Player(varchar)
The problem I run into is when I run this statement only the