cal Institute of New York
Columbia University
as867 [at] columbia {dot} edu
|-Original Message-
|From: Costas Piliotis [mailto:[EMAIL PROTECTED]]
|Sent: Friday, July 27, 2001 1:53 PM
|To: CF-Talk
|Subject: RE: come on Forta !
|
|
|Woah!
|Ansi 88 Syntax!
|Haven't seen that since Btrie
01 4:38 PM
To: CF-Talk
Subject: RE: come on Forta !
Select Books.*
>From Books,
BookAuthors,
BookCategories,
BookLanugage,
Authors,
Categories,
Languages
Where Books.BookID = BookAuthors.BookID
AND BookAuthors.AuthorID = Aut
ject: RE: come on Forta !
Come on Forta! I knew that should be a linker table
for all many to many relations. I tried to shorten the
chart.
I am a good student who read most of your books, Ben.
still need the help:
Books --- BookAuthors --- Authors
|
|- BookCategories --- Ca
able and make it relational.
-Original Message-
From: Hamid Hossain [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 2:39 PM
To: CF-Talk
Subject: RE: come on Forta !
Come on Forta! I knew that should be a linker table
for all many to many relations. I tried to shorten the
chart.
: Thursday, July 26, 2001 2:39 PM
To: CF-Talk
Subject: RE: come on Forta !
Come on Forta! I knew that should be a linker table
for all many to many relations. I tried to shorten the
chart.
I am a good student who read most of your books, Ben.
still need the help:
Books --- BookAuthors --- Authors
Come on Forta! I knew that should be a linker table
for all many to many relations. I tried to shorten the
chart.
I am a good student who read most of your books, Ben.
still need the help:
Books --- BookAuthors --- Authors
|
|- BookCategories --- Categories
you can.
the easiest tho not the most accepted way to do this is to use a union
statement.
for example:
select 1 as displayOrder, books.bookName, books.ISBN, authors.fullname as
caption
from books left join booksToAuthors on books.bookID=booksToAuthors.bookID
left join authors on booksToAuthors
ON C.Category_ID = B.Category_ID
INNER JOIN Language L ON L.Language_ID = B.Language_ID
That should be real close to what you need
-Original Message-
From: Hamid Hossain [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 11:52 AM
To: CF-Talk
Subject: come on Forta !
-Original Message-
From: Hamid Hossain [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 11:52 AM
To: CF-Talk
Subject: come on Forta !
Hi folks,
I'v just ordered Ben Forta's new book. I am woundering
if I will find a way to solve this problem. I have the
followin
Hi folks,
I'v just ordered Ben Forta's new book. I am woundering
if I will find a way to solve this problem. I have the
following database tables:
--- many -- Authors
| (Table)
|
|
|
Books - many -
10 matches
Mail list logo
