This will probably be easy for some but hard for others like myself who dont see this very much.
Here is the question. A person logs in and has a certain id associated with his profile, not his user id but his team id, I then need to match that teamid with one of two fields in the games table either the visitor id or home id, I then must take the date field, I must take the visitor and home id and match those up to teams names in another database, and then I need to take the field id and match that up to a Field name in the fields table. The most difficult part for me is getting to do this thing in the smallest amount of space and then actually constructing the SQL to query the games table, adnd taking one id and trying to find which one it matches up with in that table.
Help ... please
dan
Here is the question. A person logs in and has a certain id associated with his profile, not his user id but his team id, I then need to match that teamid with one of two fields in the games table either the visitor id or home id, I then must take the date field, I must take the visitor and home id and match those up to teams names in another database, and then I need to take the field id and match that up to a Field name in the fields table. The most difficult part for me is getting to do this thing in the smallest amount of space and then actually constructing the SQL to query the games table, adnd taking one id and trying to find which one it matches up with in that table.
Help ... please
dan