Thanks to all,
As you says me, the solution was the indexes. I didn't have an index
in results.sample_id. Now the query returns succesfully in a few
seconds, regards
Juan P. Espino
On 7/11/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> Juan Pablo Espino <[EMAIL PROTECTED]> wrot
Juan Pablo Espino <[EMAIL PROTECTED]> wrote on 07/08/2005 03:37:14 PM:
> Hello all!
>
> I have two tables in my database: results(20 000 rows) and
> data_lab1(3 000 rows) Both are related by a sample number (sample_id.)
> I need to find the samples of data_lab1 table that they are not in
> resul
Hello.
Check that MySQL doesn't hang, and that your system doesn't swap.
You can connect to MySQL server and check with 'SHOW PROCESSLIST'
states of MySQL threads. See:
http://dev.mysql.com/doc/mysql/en/show-processlist.html
Juan Pablo Espino <[EMAIL PROTECTED]> wrote:
> Hello all
Hello all!
I have two tables in my database: results(20 000 rows) and
data_lab1(3 000 rows) Both are related by a sample number (sample_id.)
I need to find the samples of data_lab1 table that they are not in
results table.
I think the following query is the solution:
SELECT data_lab1.sample_id,
Thanks to You Brent and Bill Easton
and Sorry
Hrmm , that what happen when not clipping direct into mail program ,
here is the Original :-) :
Select A.DepartmentName,A.Address,P.Postcode,P.cityname,CP.firstname
from caddress A,cpostinfo P
left Join CContactPerson CP , caddresscontactperson C
Your syntax is wrong, or at least not standard, if you are trying to do
multiple left joins.
Your ordering is not your typical for a query.
And you say "there" instead of "where".
Your query should be structure like this:
SELECT
FROM , ,...
LEFT JOIN ON
LEFT JOIN ON
LEFT JOIN ON
...
WHERE
on CACP.ContactpersonID=CP.ID and CACP.AddressID=A.ID
left join ccontactinfo CCI
on CACP.ID=CCI.AddressContactPersonID
and CCI.AddressID=-1 and CCI.ContactInfoTypeID=1
where A.ID=10 and A.PostInfoID=P.ID
> Date: Wed, 12 Nov 2003 23:20:10 +0100 (CET)
> Subject: Sql - Proble
Hello
the little Query1 works until I add the left join :
Query 1 )
Select A.DepartmentName,A.Address,P.Postcode,P.cityname
from caddress A,cpostinfo P
there A.ID=10 and A.PostInfoID=P.ID
Query 2)
Select A.DepartmentName,A.Address,P.Postcode,P.cityname,
CP.firstname
left Join CCo
o get it if people don't have to spend time figuring out what
the question is.
- Original Message -
From: "Lisi" <[EMAIL PROTECTED]>
To: "Bill Easton" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 03, 2003 3:37 AM
Subject: Re:
;re
more likely to get it if people don't have to spend time figuring out what
the question is.
- Original Message -
From: "Lisi" <[EMAIL PROTECTED]>
To: "Bill Easton" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 03, 2003 3:37
se will
then narrow the selection to the day you want.
Hope this helps
> Date: Sun, 19 Jan 2003 19:02:25 +0200
> To: [EMAIL PROTECTED]
> From: Lisi <[EMAIL PROTECTED]>
> Subject: Problem with LEFT JOIN
> I have a page with many ads that stores both the number of times
don't have data in click; the where clause will
then narrow the selection to the day you want.
Hope this helps
> Date: Sun, 19 Jan 2003 19:02:25 +0200
> To: [EMAIL PROTECTED]
> From: Lisi <[EMAIL PROTECTED]>
> Subject: Problem with LEFT JOIN
> I have a page with many
I have a page with many ads that stores both the number of times an ad is
displayed and how many times it gets clicked. These are stored in two
different tables (since different information is stored for each) but both
have identical name columns. I am trying to display both # times displayed
Hi,
i've got a really strange problem with a request using multiple left join
and order by :
Here is the first sql query :
i display two columns of my table CV and one column of table ANNOTATION_CV
SELECT ID_CV,
TITRECV,ANNOTATION_CV.ANNOTATION_CV
FROM CV
LEFT JOIN CV_POSE ON CV_POSE.FK_CV=CV.ID
* ds
> > Hi, please help me with this problem...
> >
> > Suppose i have a table whith ids and two more tables with logs like
> > this:
> >
> > table0: id1,id2
> > table1: id1,id2,date,ip
> > table2: id1,id2,date,ip
> >
> > Table0 is where i have all existent pairs (id1,id2).
> > Table1 logs all ev
> Hi, please help me with this problem...
>
> Suppose i have a table whith ids and two more tables with logs like
> this:
>
> table0: id1,id2
> table1: id1,id2,date,ip
> table2: id1,id2,date,ip
>
> Table0 is where i have all existent pairs (id1,id2).
> Table1 logs all events of type 1.
> table2
At 12:57 PM -0700 11/15/01, Mark A Ohrenschall wrote:
>I'm having a problem with Distrib 3.23.42 with the following query:
>
>select x1.*,x2.* from x1 left join x2 on x1.d1=x2.d2 where x2.d2 is null;
>
>I'm finding that a left join on datetime fields that do not allow nulls is not
>working when I'
I'm having a problem with Distrib 3.23.42 with the following query:
select x1.*,x2.* from x1 left join x2 on x1.d1=x2.d2 where x2.d2 is null;
I'm finding that a left join on datetime fields that do not allow nulls is not
working when I'm trying to emulate a subselect to find non-matching values
>Description:
When i want to find the next unused id from a table joining it whith another
table the result is allways 1, even though this is not correct
>How-To-Repeat:
create table a (id int not null primary key);
create table b (id int not null primary key);
insert into
Hello,
Can any of you explain me why, when i do this request :
select count(*)
from OBJET as t1 left join COLLECTION as t2
ON t1.numColl = t2.numColl
where t2.numSupp = 0;
I've got an error saying : Field numObj not found
note that numObj is the Key of table OBJET...
Thank's
--
Best regards
20 matches
Mail list logo
