Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-23 : 21:10:56
|
vinod writes "i have the following tables
---------------------------
first table name author with the
following coloumns
author_id,author_name,etc
----------------------------
second table name book_author with the
following coloumns
author_id,author_name.
---------------------------
third table name books with the
following coloumns
books_id,book_title.
---------------------------
book_author table relate
the author table and books table
---------------------------
i want select the record from these tables
record sholud be like
book_title along with author_name in MS-ACCESS DATABASE
please keep in mind that some books
may have multiple authors
------------
please help me
waiting for reply" |
|
|
|
|
|
sql ask