On 7/14/08, Ralf Jantschek <[EMAIL PROTECTED]> wrote:
> Hello,
>
>
>
> I'm having problems with Inner Joins on m:n relations
>
> book <--> bookauthor <--> author
>
>
>
> SELECT authorname FROM author INNER JOIN book INNER JOIN bookauthor ON
> book.Id_book = bookauthor.Id_book ON
Hello,
I'm having problems with Inner Joins on m:n relations
book <--> bookauthor <--> author
SELECT authorname FROM author INNER JOIN book INNER JOIN bookauthor ON
book.Id_book = bookauthor.Id_book ON author.Id_author = bookauthor.Id_author
WHERE bookltitle='title'
I receive an
2008/7/14 Ralf <[EMAIL PROTECTED]>:
> I'm having problems with Inner Joins on m:n relations
>
> book <--> bookauthor <--> author
>
> SELECT authorname FROM author INNER JOIN book INNER JOIN bookauthor ON
> book.Id_book = bookauthor.Id_book ON author.Id_author = bookauthor.Id_author
> WHERE
Hello,
I'm having problems with Inner Joins on m:n relations
book <--> bookauthor <--> author
SELECT authorname FROM author INNER JOIN book INNER JOIN bookauthor ON
book.Id_book = bookauthor.Id_book ON author.Id_author = bookauthor.Id_author
WHERE bookltitle='title'
I receive an
On 3/2/06, erw2 <[EMAIL PROTECTED]> wrote:
>
> Now I try to execute SQL query:
> SELECT PomiarBledow.IDpomiaru, Samochody.Samochod
> FROM (PomiarBledow INNER JOIN Modele ON PomiarBledow.IDmod =
> Modele.IDmod) INNER JOIN Samochody ON Modele.IDsam = Samochody.IDsam
> WHERE
Hi sqlite-users,
I have a following problem. In my database there are 3 table:
CREATE TABLE [Samochody]
(
[IDsam] integer,
[Samochod] varchar (50),
PRIMARY KEY ([IDsam])
);
CREATE TABLE [Modele]
(
[IDmod] integer,
[IDsam] integer,
[Model] varchar
Christoph Gassmann | aquantum GmbH wrote:
> I have a log-Table of a webpage-logger and for faster selects i need
> the seconds between to clicks.
>
> I found out a select-statement that produces the seconds. Here it is:
>
> SELECT round(julianday(t2.dTimestamp)*86400 -
>
7 matches
Mail list logo