Review your join type.
From: ext Gavin Towey [gto...@ffn.com]
Sent: 16 August 2010 19:36
To: Victor Subervi; mysql@lists.mysql.com
Subject: RE: Join Problem
What do you mean by "not working?" What results do you get?
-Original Message
What do you mean by "not working?" What results do you get?
-Original Message-
From: Victor Subervi [mailto:victorsube...@gmail.com]
Sent: Monday, August 16, 2010 6:59 AM
To: mysql@lists.mysql.com
Subject: Join Problem
Hi;
I have this code:
select f.id from Flights f join Planes p where
On Feb 17, 2005, at 10:34 AM, [EMAIL PROTECTED] wrote:
Albert Padley <[EMAIL PROTECTED]> wrote on 02/17/2005 12:08:31 PM:
> I have the following 2 tables:
>
> CREATE TABLE `division_info` (
> `id` int(11) NOT NULL auto_increment,
> `division` varchar(50) NOT NULL default '',
> `spot
Michael Dykman <[EMAIL PROTECTED]> wrote on 02/17/2005 12:20:44 PM:
> On Thu, 2005-02-17 at 12:08, Albert Padley wrote:
> > I have the following 2 tables:
> >
> > CREATE TABLE `division_info` (
> >`id` int(11) NOT NULL auto_increment,
> >`division` varchar(50) NOT NULL default '',
> >
s only for compatibility with odbc".
> thanks!
>
> >From: Michael Dykman <[EMAIL PROTECTED]>
> >To: Albert Padley <[EMAIL PROTECTED]>
> >CC: "\"MySQL List\""
> >Subject: Re: JOIN Problem
> >Date: Thu, 17 Feb 2005 12:20
Albert Padley <[EMAIL PROTECTED]> wrote on 02/17/2005 12:08:31 PM:
> I have the following 2 tables:
>
> CREATE TABLE `division_info` (
>`id` int(11) NOT NULL auto_increment,
>`division` varchar(50) NOT NULL default '',
>`spots` int(11) NOT NULL default '0',
>PRIMARY KEY (`id`),
>
CTED]>
CC: "\"MySQL List\""
Subject: Re: JOIN Problem
Date: Thu, 17 Feb 2005 12:20:44 -0500
On Thu, 2005-02-17 at 12:08, Albert Padley wrote:
> I have the following 2 tables:
>
> CREATE TABLE `division_info` (
>`id` int(11) NOT NULL auto_increment,
>`divis
On Thu, 2005-02-17 at 12:08, Albert Padley wrote:
> I have the following 2 tables:
>
> CREATE TABLE `division_info` (
>`id` int(11) NOT NULL auto_increment,
>`division` varchar(50) NOT NULL default '',
>`spots` int(11) NOT NULL default '0',
>PRIMARY KEY (`id`),
>KEY `division`
Thanks for the suggestion, but according to explain we are in worse shape
than before. In both cases the multi-column index is ignored. I am going to
try fiddling with the index col order to see if this helps.
Here is what it comes up with as you suggested:
Query1:
explain SELECT COUNT(*) as Nu
Friday, May 30, 2003 3:42 PM
To: [EMAIL PROTECTED]
Cc: Susan Ator
Subject: RE: Join problem
> Well, I'm running 3.23.54 on Red Hat 7.3. Given this, how in the world
> do I accomplish the following:
>
> I have these tables:
> dacspriv - with d
; -Original Message-
> From: Ryan McDougall [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 30, 2003 12:11 PM
> To: mysql
> Subject: Re: Join problem
>
>
>> Short answer is mysql does not do sub-selects (i.e., a select inside
>> of a select). The join part is not th
>> Short answer is mysql does not do sub-selects (i.e., a select inside
>> of a select). The join part is not this issue.
>
> Wouldn't this depend on the version... I thought the newest versions,
> 4.x+, supported sub-selects.
>
> Ryan
>
> __
> Do you Yahoo!?
> Yahoo
Sent: Friday, May 30, 2003 12:11 PM
To: mysql
Subject: Re: Join problem
> Short answer is mysql does not do sub-selects (i.e., a select inside of a
> select). The join part is not this issue.
Wouldn't this depend on the version... I thought the newest versions, 4.x+,
supported su
> Short answer is mysql does not do sub-selects (i.e., a select inside of a
> select). The join part is not this issue.
Wouldn't this depend on the version... I thought the newest versions, 4.x+,
supported sub-selects.
Ryan
__
Do you Yahoo!?
Yahoo! Calendar - Free
> O. I've got a headache trying to understand joins. I'm definitely
> NOT a database guru.
>
> Why in the world doesn't this work?
>
>
> SELECT dacspriv_name
> FROM dacspriv
> WHERE dacspriv_id not in (SELECT dacspriv_id
> FROM dacs_access JOIN users
> ON dacs_access.user_id=users.user_id
> WHE
Stefan Hinz wrote:
Okay, here for another wild guess:
SELECT u.login, p.name, sp.name, SUM(t.time)
FROM t_user u
LEFT JOIN t_project p ON 1
LEFT JOIN t_subproject sp ON p.id = sp.project_id
LEFT JOIN t_time t ON ?? = ??
WHERE u.login = 'amg'
GROUP BY p.name
Where I'm not sure if you will need t
Sorin,
> If there are entries which are:
> 60 / amg / 5
> 120 / amg / 5
> (in this example '5' is the id of the calculation-subproject)
> Then the result should be:
> +---+---+---+---+
> | login | name | name |
Defryn,
Monday, July 08, 2002, 5:09:51 AM, you wrote:
D> Can anyone have a look at my join.
D> It returns errors
D> Select O.name, O.amount , P.Productname, P.price
D> From Orders AS O
D> JOIN Products AS P ON O.product=P.Productid
D> Where O.cluster= 'ANP';
D> It works fine when I use
D> Sel
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
Dave Butler wrote:
> I am struggling with a join query using MySQL 3.23.31 under AIX 4.3.3.
> Here are the tables involved:
>
> select CAT.linenum, CAT.acct, FD.amount
> from sched_acct_cat CAT LEFT JOIN fd FD
> ON CAT.acct = FD.acct
> where CAT.sched_acct = 'INC_STMT'
> AND FD.entity='FMCI'
Neil,
I did a quick test of your data and this is what I got to work.
SELECT item.item, titles.title FROM item LEFT JOIN titles ON
item.title_id = titles.title_id;
The left join selects all the items from the 'left' table even if there
are no matching entries in the 'right' table. A bit of a w
You could try using an AND in the WHERE statement.
EG. SELECT DISTINCT R.ID, R.CatCode, R.Title
FROM Recipes R, Ingredients I
WHERE I.Description LIKE "%$SearchKey%"
AND R.ID = I.ID;
Hope this helps.
Andrew Murphy
-Original Message-
From: Urb LeJeune [mailto:[EMAIL PRO
22 matches
Mail list logo
