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
