ISO: Someone with knowledge in microsoft access

[privateone]

Hey guys, I dont know if this is the right thread, sorry if it isnt,


create two queries linking these tables together using primary keys

My directions so far..  I'm completely lost, thank you for any help

[Jen]

I would gladly tell you if I knew, but I don't. Sorry.

[pikachu]

privateone:
Chances are you're looking for a primary key and a foreign key.  Imagine two tables, Schools and Students, where each school has a unique field (primary key) called ID, and each student has a field (foreign key) School that "points" to the Schools table's primary key (ID).  Might look something like this:

----
Schools
----
ID
Name
...

----
Students
----
School
FirstName
LastName
...

Then to merge all of the schools and students into one large list of tuples, you could use an implicit left inner join:

select * from Schools, Students where Students.School = Schools.ID;

Is that what you're looking for?

[pikachu]

Topic cleaned.  Warden is in the Attic.

[ben_fb]

pikachu's code looks accurate at a glance