-
Feb 22nd, 2012, 03:48 AM
#1
Thread Starter
Hyperactive Member
How to read this querry
select a.lib_book_title,a.lib_book_author_name as Author,b.category_name from lib_book_details a join lib_book_categories b on b.category_id = a.lib_book_category join lib_book_issue_details c on c.lib_book_id = a.lib_book_id where c.lib_book_issued_to = '" + Globals.UserName + "'"
there is two join operator and i m confuse how to read
-
Feb 22nd, 2012, 08:53 AM
#2
Re: How to read this querry
It's just getting one record with information from three tables. Let's say that you had a Person table, a Dog table and a Cat table. Such a query would allow you to get a single record containing the name of a person, the name of their dog and the name of their cat. Both the Dog and Cat tables would contain a PersonID column and they would be used to join those two tables with the Person table.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|