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.