Ok im catching on now but I am trying to create the table using your query and I am getting the following

Incorrect syntax near ')'.

in the last line. I...

Ok but if

team a trades kenny to team b

team b trades jack to team c

and team c trades ben to team a

how will know who was traded to who?

Im confused,

I dont understand how I would know what team a player or pick was traded to? What if it is a three team transaction? I also dont...

When trades are done they typicaly are not even

team a might give team b 2 players for one pick

or any combination

I have a player table that has ID's for all...

That is awsome thank you for your time. I have one follow up question how can I get it to format the results in typical standings table format

WP =...