Tables, Relationships, and queries.

[Andyjones]

Could someoone please take a look at the link below to see what i am doing wrong with the tables and relationships.



and the query does not work correctly, please feel free to adjust the tables and relationships etc or add tables, or instruct me on what i need to do.

http://www.box.com/s/d2sim8hmyks82f05rmuy

[cap.zadi]

Hey,

if you tell us what kind of results u are expecting from this query so would be very help to understand the problem otherwise this query is working fine.

regards

zee

[Andyjones]

The problem I am having is this,

The two results tables home and away are ment to be added up in the query like so.

PLayed won lost fr against plus minus.

It does not seem to be working. it only adds up score plus minus points

also if a player has only played one game either home or away it does not show player played one game won won game. etc.

its like a league table in football.

so if any new tables need to be create or changed or relationships need changing please feel free to mess around with it.