Query-ing multiple tables.
I have a database, which contains two tables:
ID; Firstname; Lastname; Log-in; Password; Base.
ID; Type; Level; Coordinates.
Now would I like to get a query that does the following:
A: Look what player is accessing the page to determine his base coords (the player is logg-ed in to the site, so he has a valid session going);
B: Extract the required data (the player can set the criteria trough a form!)
C: Post the extracted data onto the site.
The site it's about:
Could someone please advise?
You need to create a key in every table