Thank you gentlemen.
Questions &/or comments annotated below:
Walter Heck wrote:
> The 'AS' keyword for tables is just to give a table an alias by which
> you can then use it in the rest of the query. In your case, when you
> say 'book as b' in your query, it means that you can use b in places
> w
The 'AS' keyword for tables is just to give a table an alias by which
you can then use it in the rest of the query. In your case, when you
say 'book as b' in your query, it means that you can use b in places
where you need to refer to the book table. eg. 'b.id' refers to the
'id' field of the 'book
Gentlemen,
and all those who care,
THE PROBLEM SEEMS TO BE SOLVED (for now, NEXT is HOW TO QUERY(SELECT)
MULTIPLE AUTHORS AND DISPLAY THAT and then HOW TO DEAL WITH MULTIPLE
CATEGORIES (heh... heh... heh ;-) :
"SELECT b.title, b.sub_title, b.descr, b.comment, b.bk_cover,
b.copyright, b.ISBN, c.pu
Claudio Nanni wrote:
> Hi Phil,
> you seem quite a bit confused!
>
> I would not step to use joins before understanding the 'simple' logic
> behind,
> otherwise you will be always confused by the syntax.
> There are many, many, many resources (thanks to Tim!)
>
> I will try to give you a simple ove
Hi Phil,
you seem quite a bit confused!
I would not step to use joins before understanding the 'simple' logic
behind,
otherwise you will be always confused by the syntax.
There are many, many, many resources (thanks to Tim!)
I will try to give you a simple overview of joins but please get more
co
I have been searching and searching for a clear and logical explanation
of JOINs and have found nothing that can be reasonably understood.
Perhaps I am dense or from another planet, but nothing seems to fall
into place.
I need to display all the books (with their respective authors and
publishers)
