Nuno Pereira <[EMAIL PROTECTED]> wrote on 08/26/2005 02:30:08 PM:
> [EMAIL PROTECTED] wrote:
> > Nuno Pereira <[EMAIL PROTECTED]> wrote on 08/26/2005 02:08:50
PM:
> >
> >
> >>Hi list,
> >>
> >>I have a query like this (the original is very big and names of
> >>columns/tables are in portuguese)
Sorry for replying to mysqlf, but it really solved the problem: there
were another JOIN that had to be transformed to a LEFT JOIN.
Thanks.
Nuno Pereira wrote:
[EMAIL PROTECTED] wrote:
Nuno Pereira <[EMAIL PROTECTED]> wrote on 08/26/2005 02:08:50 PM:
Hi list,
I have a query like this (th
[EMAIL PROTECTED] wrote:
Nuno Pereira <[EMAIL PROTECTED]> wrote on 08/26/2005 02:08:50 PM:
Hi list,
I have a query like this (the original is very big and names of
columns/tables are in portuguese):
SELECT * FROM tbl1 t JOIN tbl2 u ON (t.id_tbl2=u.id)
For a schema like this:
CREATE TABLE
Nuno Pereira <[EMAIL PROTECTED]> wrote on 08/26/2005 02:08:50 PM:
> Hi list,
>
> I have a query like this (the original is very big and names of
> columns/tables are in portuguese):
>
> SELECT * FROM tbl1 t JOIN tbl2 u ON (t.id_tbl2=u.id)
>
> For a schema like this:
>
> CREATE TABLE tbl2 (
>
Hi list,
I have a query like this (the original is very big and names of
columns/tables are in portuguese):
SELECT * FROM tbl1 t JOIN tbl2 u ON (t.id_tbl2=u.id)
For a schema like this:
CREATE TABLE tbl2 (
id INT NOT NULL auto_increment PRIMARY KEY,
data_col2 int NOT NULL
) ENGINE=InnoDB;
CR
