Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Database > SQL query help

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

SQL query help

Reply to Message Icon

Name: ShaqDiesel
Date: May 26, 2008 at 16:40:38 Pacific
OS: winXP
CPU/Ram: Amd64/1Gb
Product: custom
Comment:

I have 3 tables, books, authors, and togetherTable.
1.books with book_id(primary key), book_cover_image, and book_title.

2.authors with author_id and author_name

3.togetherTable with book_id and author_id

How do I get the book_cover_image, title, and author for all the records in my database?

I started off with: SELECT book_cover_image, title, author FROM books, authors, togetherTable WHERE

but I don't know how to finish it.



Sponsored Link
Ads by Google

Response Number 1
Name: orange
Date: June 2, 2008 at 21:38:00 Pacific
Reply:


SELECT
book_cover_image, book_title, author_name
FROM
books, authors, togetherTable
WHERE
books.book_id = togetherTable.book_id AND
authors.author_id = togetherTable.author_id;


0
Reply to Message Icon

Related Posts

See More



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links
Ads by Google


Results for: SQL query help
SQL Query Help www.computing.net/answers/dbase/sql-query-help/653.html

Need help with SQL-query (access) www.computing.net/answers/dbase/need-help-with-sqlquery-access/209.html

MS Access SQL query www.computing.net/answers/dbase/ms-access-sql-query/286.html