is not 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
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
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,
, 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 using mysql
(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
PROTECTED]
- Original Message -
From: Mehdi Roomi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 06, 2002 6:37 AM
Subject: complex sql query...
Hi,
Suppose there is a sql table with the following fields and values
Hi,
Suppose there is a sql table with the following fields and values:
+-+
|username|start|stop |sessiontime|
++-+--+---+
|mehdi |
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
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
: 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 time
10 matches
Mail list logo