• January 27, 2023, 10:54:02 pm

Author Topic: ISO: Someone with knowledge in microsoft access  (Read 2110 times)

privateone

  • Newbie
  • *
  • Posts: 2
ISO: Someone with knowledge in microsoft access
« on: April 29, 2011, 11:56:07 pm »
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

  • Pro Ninja
  • Hero Member
  • *******
  • Posts: 1,240
Re: ISO: Someone with knowledge in microsoft access
« Reply #1 on: April 30, 2011, 10:00:42 am »
I would gladly tell you if I knew, but I don't. Sorry.
« Last Edit: April 30, 2011, 02:09:21 pm by pikachu »

pikachu

  • Administrator
  • Hero Member
  • *******
  • Posts: 3,344
Re: ISO: Someone with knowledge in microsoft access
« Reply #2 on: April 30, 2011, 10:48:41 am »
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?
« Last Edit: April 30, 2011, 02:11:11 pm by pikachu »

pikachu

  • Administrator
  • Hero Member
  • *******
  • Posts: 3,344
Re: ISO: Someone with knowledge in microsoft access
« Reply #3 on: April 30, 2011, 02:09:42 pm »
Topic cleaned.  Warden is in the Attic.
This post has been thanked 1 time Jen

ben_fb

  • Addict
  • *****
  • Posts: 246
Re: ISO: Someone with knowledge in microsoft access
« Reply #4 on: April 30, 2011, 07:00:41 pm »
pikachu's code looks accurate at a glance

 

newBalance by DzinerStudio