So you now have One database with two tables? Each table has a different
version of the Bible in it?
If that's the case then my example would work, but change out the book names
to something like
SELECT KJV.book,
NIV.book,
Etc....
Hope that makes sense...
Bill
-----Original Message-----
From: Tony Hicks [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 7:51 AM
To: SQL
Subject: Re: Identical Table structures..
oops forgot..
because the database i picked up was flat file texts.. 66 of them so i just
imported and cleaned them up but now ive found two access dbs with the
American Standard and KJV Bibles in them so I merged them into one db with
two tables, that's all
Thanks
Tony Hicks
----- Original Message -----
From: Daniel Lancelot <[EMAIL PROTECTED]>
To: SQL <[EMAIL PROTECTED]>
Sent: Wednesday, May 30, 2001 6:42 AM
Subject: RE: Identical Table structures..
> but then how would the tables be related, (IE wouldnt a cartessian join
> result), and 66 ID's would have to be checked to find the correct value.
>
> TONY: can you explain why the books are kept in separate tables???
>
> -----Original Message-----
> From: Bill Killillay [mailto:[EMAIL PROTECTED]]
> Sent: 30 May 2001 12:39
> To: SQL
> Subject: RE: Identical Table structures..
>
>
> In your search queries you need to assign a row alias...
>
> i.e.
>
> Select Genesis.book,
> Genesis.id,
> Exidus.book,
> Exidus.id,
> Etc...
> >From
> Where...
>
> Hope that helps
>
> -----Original Message-----
> From: Tony Hicks [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 30, 2001 3:47 AM
> To: SQL
> Subject: Identical Table structures..
>
>
> I come up with ingenious ways for CF to tell me the code won't work..
>
> I have a Bible Database... 66 books = 66 tables, no problem, right?
Wrong...
>
> Each table has an Identical structure
>
> ID, Chapter, Verse, Text
>
> Is there a way to query all 66 tables through a search? When I did I got
an
> error because two or more fields had the same name... or can anyone think
of
> a quick fix? Making one change 66 times is alot of work!
>
> Tony Hicks
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
