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
