On Monday 01 April 2002 10:56 am, IvanLatysh wrote:
> Hi.
> I am running MySQL 3.23.44-Max
>
> I have 2 tables.
>
> Table "A"
> +---++
> IDName
> +---++
> 1 string 1
> 2 string 2
> +---++
>
> Table "B"
>
> +---++
> IDName
> +---++
> 2
Hi.
I am running MySQL 3.23.44-Max
I have 2 tables.
Table "A"
+---++
IDName
+---++
1 string 1
2 string 2
+---++
Table "B"
+---++
IDName
+---++
2 string 2
3 string 3
+---++
And I need result
+---++
ID
* Miretsky, Anya
> Select distinct
> biblio.* from biblio left join keyword on
> biblio.p_biblio=keyword.fk_biblio
> where keyword="SOMESTRING";
Try swapping the tables:
Select distinct
biblio.* from keyword left join biblio on
biblio.p_biblio=keyword.fk_biblio
where keyword="SOMESTRING";
The l
possibly
-Original Message-
From: Miretsky, Anya [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 2:32 PM
To: 'Rick Emery'
Subject: RE: Left Join problem - Please Help
When I do this without specifying a left join with just :select biblio.*
from biblio,keyword wher
he mysql list to see what the experts think.
-Original Message-
From: Miretsky, Anya [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 2:17 PM
To: 'Rick Emery'
Subject: RE: Left Join problem - Please Help
Biblio has 11,901 and keyword has 87,971, also I indexed the
Show us your table structure, some table values and the SELECT statement
that works and the one that doesn't
-Original Message-
From: Miretsky, Anya [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 12:13 PM
To: '[EMAIL PROTECTED]'
Subject: Left Join proble
Whenever I try to issue a query which has a left join for two tables and a
where clause for a column in the second table that is a varchar the query
runs indefinitely. If I change the where clause to search on a numeric type
column the query runs and returns expected values.
Does anyone know what
