Hello,
> okay... 1< Your result will be a binary number... which will be the number 1 followed
> by table1.sid 0's. Once you have this you do a bitwise or of all the
> numbers you have shifted. This means any two rows where sid was the same
> will be combined, as there is no difference between
- Original Message -
From: "Bas Jobsen" <[EMAIL PROTECTED]>
To: "Sheridan Saint-Michel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 04, 2001 7:17 PM
Subject: Re: [PHP-DB] Howto make a double LEFT JOIN
> Hello Sheridan
t; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, October 03, 2001 2:52 PM
> Subject: Re: [PHP-DB] Howto make a double LEFT JOIN
>
>
> > Hello Sheridan Saint-Michel,
> >
> > Let's see.
> >
> > Table2 contains data with a un
Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
- Original Message -
From: "Bas Jobsen" <[EMAIL PROTECTED]>
To: "Sheridan Saint-Michel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 03, 2001 2:52
each count is on a row apart. Each row in this
table contains a timestamp, so i could do something like "DELETE FROM Table1
WHERE time
To: "Bas Jobsen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 03, 2001 6:34 PM
Subject: Re: [PHP-DB] Howto make a do
EMAIL PROTECTED]>
Sent: Tuesday, October 02, 2001 4:59 PM
Subject: Re: [PHP-DB] Howto make a double LEFT JOIN
> Hi Rick,
>
> > please show the REAL output from your query and what it should REALLY
look
> > like
>
> table1:
> id|no
> 1|1
> 2|1
>
> tabl
"'Bas Jobsen'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 02, 2001 11:11 PM
Subject: RE: [PHP-DB] Howto make a double LEFT JOIN
> please show the REAL output from your query and what it should REALLY look
> like
>
> -Original Message-
please show the REAL output from your query and what it should REALLY look
like
-Original Message-
From: Bas Jobsen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 3:38 PM
To: Rick Emery; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Howto make a double LEFT JOIN
> SELECT tab
"Rick Emery" <[EMAIL PROTECTED]>
To: "'Bas Jobsen'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 02, 2001 10:19 PM
Subject: RE: [PHP-DB] Howto make a double LEFT JOIN
> SELECT table1.id FROM table1 LEFT JOIN table2 ON tabl
SELECT table1.id FROM table1 LEFT JOIN table2 ON table1.id=table2.id LEFT
JOIN table3 ON table2.id=table3.id
-Original Message-
From: Bas Jobsen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 3:13 PM
To: Rick Emery; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Howto make a double
> Remove the parentheses
> SELECT table1.id FROM table1 LEFT JOIN table2 LEFT JOIN table3 ON
> table2.id=table3.id ON table1.id=table2.id
I still got:
MySQL retourneerde: You have an error in your SQL syntax near 'LEFT JOIN
table3 ON
table2.id=table3.id ON table1.id=table2.id' at line 1
--
PHP
Remove the parentheses
SELECT table1.id FROM table1 LEFT JOIN table2 ON table1.id=table2.id LEFT
JOIN table3 ON table2.id=table3.id
-Original Message-
From: Bas Jobsen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 3:00 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Howto make a
Remove the parentheses
SELECT table1.id FROM table1 LEFT JOIN table2 LEFT JOIN table3 ON
table2.id=table3.id ON table1.id=table2.id
-Original Message-
From: Bas Jobsen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 3:00 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Howto make a
13 matches
Mail list logo
