Table: bible
|
id |
book |
book_spoke |
recordType |
book_title |
chap |
chapter |
chapter_spoke |
verse |
vers |
verse_spoke |
text_data |
|
1 |
001 |
001 |
gn |
Genesis |
1 |
001 |
001 |
001 |
1 |
001 |
In the beginning God created the heaven and the earth. |
|
2 |
001 |
001 |
gn |
Genesis |
1 |
001 |
001 |
002 |
2 |
002 |
And the earth was without form, and void; and darkness was upon
the face of the deep. And the Spirit of God moved upon the face of the
waters. |
|
3 |
001 |
001 |
gn |
Genesis |
1 |
001 |
001 |
003 |
3 |
003 |
And God said, Let there be light: and there was light. |
|
4 |
001 |
001 |
gn |
Genesis |
1 |
001 |
001 |
004 |
4 |
004 |
And God saw the light, that it was good: and God divided the
light from the darkness. |
|
5 |
001 |
001 |
gn |
Genesis |
1 |
001 |
001 |
005 |
5 |
005 |
And God called the light Day, and the darkness he called Night.
And the evening and the morning were the first day. |
|
6 |
001 |
001 |
gn |
Genesis |
1 |
001 |
001 |
006 |
6 |
006 |
And God said, Let there be a firmament in the midst of the
waters, and let it divide the waters from the waters. |
|
7 |
001 |
001 |
gn |
Genesis |
1 |
001 |
001 |
007 |
7 |
007 |
And God made the firmament, and divided the waters which were
under the firmament from the waters which were above the firmament: and it
was so. |
|
8 |
001 |
001 |
gn |
Genesis |
1 |
001 |
001 |
008 |
8 |
008 |
And God called the firmament Heaven. And the evening and the
morning were the second day. |
|
9 |
001 |
001 |
gn |
Genesis |
1 |
001 |
001 |
009 |
9 |
009 |
And God said, Let the waters under the heaven be gathered
together unto one place, and let the dry land appear: and it was so. |
|
10 |
001 |
001 |
gn |
Genesis |
1 |
001 |
001 |
010 |
10 |
010 |
And God called the dry land Earth; and the gathering together of
the waters called he Seas: and God saw that it was good. |
|
11 |
001 |
001 |
gn |
Genesis |
1 |
001 |
001 |
011 |
11 |
011 |
And God said, Let the earth bring forth grass, the herb yielding
seed, and the fruit tree yielding fruit after his kind, whose seed is in
itself, upon the earth: and it was so. |
Table: biblewheel_url
|
letter_id |
book_spoke |
chapter_spoke |
verse_spoke |
url |
|
1 |
001 |
001 |
001 |
/Wheel/Spokes/Aleph_God.asp |
|
2 |
002 |
002 |
002 |
/Wheel/Spokes/beyt_division.asp |
|
3 |
003 |
003 |
003 |
/Wheel/Spokes/Gimel_Giver.asp |
|
4 |
004 |
004 |
004 |
/Wheel/Spokes/Dalet.asp |
|
5 |
005 |
005 |
005 |
/Wheel/Spokes/Heh_Day.asp |
|
6 |
006 |
006 |
006 |
/Wheel/Spokes/Vav.asp |
|
7 |
007 |
007 |
007 |
/Wheel/Spokes/Zayin_judge.asp |
|
8 |
008 |
008 |
008 |
/Wheel/Spokes/Chet_AV.asp |
|
9 |
009 |
009 |
009 |
/Wheel/Spokes/Tet_AV.asp |
|
10 |
010 |
010 |
010 |
/Wheel/Spokes/Yod.asp |
|
11 |
011 |
011 |
011 |
/Wheel/Spokes/Kaph.asp |
|
12 |
012 |
012 |
012 |
/Wheel/Spokes/Lamed.asp |
|
13 |
013 |
013 |
013 |
/Wheel/Spokes/mayim.asp |
|
14 |
014 |
014 |
014 |
/Wheel/Spokes/nun.asp |
|
15 |
015 |
015 |
015 |
/Wheel/Spokes/samek.asp |
|
16 |
016 |
016 |
016 |
/Wheel/Spokes/ayin_EyesOfGod.asp |
|
17 |
017 |
017 |
017 |
/Wheel/Spokes/Peh_Coming.asp |
|
18 |
018 |
018 |
018 |
/Wheel/Spokes/Tsaddi.asp |
|
19 |
019 |
019 |
019 |
/Wheel/Spokes/quph_needle.asp |
|
20 |
020 |
020 |
020 |
/Wheel/Spokes/resh_health.asp |
|
21 |
021 |
021 |
021 |
/Wheel/Spokes/Shin_Sent.asp |
|
22 |
022 |
022 |
022 |
/Wheel/Spokes/tav_Seal.asp |
WHat I'm looking for is to join the tables where the book_spoke values equal. WHere should the primary key be in each? I've set the bible's in the id but in the biblewheel_url in the book_spoke.