great! hope it works !
-Original Message-
From: Richard Bolen [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 9:17 AM
To: MySQL Mailing List (E-mail)
Cc: Edward Peloke
Subject: RE: Complex SQL query problem...
FYI - this query seemed to work.
select * from nodes
left join
NULL) or (colors.parent_id
is not NULL))
I need to do some more testing to be sure.
Rich
-Original Message-
From: Edward Peloke [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 08:46
To: Richard Bolen
Subject: RE: Complex SQL query problem...
After I sent this it hit me
(E-mail)
Subject: RE: Complex SQL query problem...
try a left join
select count(*) from jobs
left join submissions on
jobs.standard_id=submissions.color_id
where jobs.standard_id=ID_VALUE and submissions.color_id is null
Eddie
-Original Message-
From: Richard
, September 20, 2002 2:37 PM
To: MySQL Mailing List (E-mail)
Subject: Complex SQL query problem...
I'm trying to use a sql query to determine if an ID exists in any of 3
different tables in the database. I need to do this in one SQL query
(ideally only using the ID once in the query). I'm u
I'm trying to use a sql query to determine if an ID exists in any of 3 different
tables in the database. I need to do this in one SQL query (ideally only using the ID
once in the query). I'm using mysql 3.23.47.
Here's an example of a query I came up with:
select count(*) from jobs, submissi
EC_TO_TIME.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -
From: "Mehdi Roomi" <[EMAIL PROTECTED]>
To: <
Hi,
Suppose there is a sql table with the following fields and values:
+-+
|username|start|stop |sessiontime|
++-+--+---+
|mehdi | 2002-08-12
Greetings:
Prelude: We have five tables all sharing a very similar structure (each has
a Customer_ID and Server_ID field for example).
Each table can contain zero to many records with duplicate Server_ID values
allowed.
Need: I need to be able to count the distinct Server_ID's across all of t
Sent: Wednesday, March 28, 2001 15:53
To: Alberni-dot-Net
Cc: [EMAIL PROTECTED]
Subject: RE: Complex SQL Query
Aaron,
Are you inserting both values at once? Or inserting the startdate first,
then
updating the stopdate later. You may or may not be able to do this in one
query.
To determine how much ti
on doesn't take into account if the startdate/stopdate spans more
than two days
HTH, and good luck, and if you're in a good mood, can you send me your final
solution;)
christopher oson
-Original Message-
From: Alberni-dot-Net [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 2
I have been trying for the last while to come up with a query that will do
the following:
Say I have table with these records:
StartDate StopDate
---
2001-01-23 23:43:12 2001-01-24 04:29:12
2001-01-24 15:24:00 2001-01-26 01:15
11 matches
Mail list logo
