Hallo,
folgendes Szenario:
Tabelle Sales (s) mit jede Menge Abverkaufsdaten.
ArtikelNr,Kassenbon,HändlerID,Datum
Jetzt sollen alle zu einem gekauften Artikel ebenfalls augelistet
werden, d.h. was wurde mit dem Artikel zusätzliche gekauft
Bisher habe ich das mit PHP gemacht, nur macht jetzt
At 7:45a -0500 on 17 Dec 2007, Marcus Füg wrote:
Tabelle Sales (s) mit jede Menge Abverkaufsdaten.
ArtikelNr,Kassenbon,HändlerID,Datum
Jetzt sollen alle zu einem gekauften Artikel ebenfalls augelistet
werden, d.h. was wurde mit dem Artikel zusätzliche gekauft
Bisher habe ich das mit PHP
Could someone please tell me what is wrong with this query:
select * from personnel where dept_id not in (select dept_id from
attendance_respond)
I keep getting a 1024 error message. It looks pretty straightforward to me.
I am running 4.0.16 on Redhat Linux 8.
--
MySQL General Mailing List
At 2:28 PM -0500 11/17/03, Peter J. Krawetzky wrote:
Could someone please tell me what is wrong with this query:
select * from personnel where dept_id not in (select dept_id from
attendance_respond)
I keep getting a 1024 error message. It looks pretty straightforward to me.
I am running 4.0.16
Rompaey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: count in subselect problem
Date: Fri, 24 Jan 2003 16:18:04 +0100
MIME-Version: 1.0
Content-Type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express
1st problem:
SELECT F.id,
F.title,
F.description,
F.created,
(select count(*) from forum F, topic T where F.id=T.forum_id AND
T.reply_id=0 ) count1,
(select count(*) from forum F, topic T where F.id=T.forum_id )
count2
SELECT textid, title, description from structure where textid in (select
subtopicid from subtopic where topicid='Top');
this gives an error at the opening bracket.. I am assuming that mysql
realises that
structure.textid=subtopic.subtopicid
...any ideas on getting this working?
thanks for
everyone knows, and everyone will want to comment on.
Good luck,
Dan
-Original Message-
From: Alex Speed [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 5:13 PM
To: [EMAIL PROTECTED]
Subject: SubSelect Problem
SELECT textid, title, description from structure where textid in (select
, or break the operation into
your application.
Eric Mayers
Software Engineer I
Captus Networks
-Original Message-
From: Alex Speed [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 4:13 PM
To: [EMAIL PROTECTED]
Subject: SubSelect Problem
SELECT textid, title, description from
Hi Alex,
MySQL doesn't support sub-selects yet.
Gurhan
-Original Message-
From: Alex Speed [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 7:13 PM
To: [EMAIL PROTECTED]
Subject: SubSelect Problem
SELECT textid, title, description from structure where textid in (select
Ok, no support for it (d'oh), so, how do I go about breaking it down into a
join or something like that?
- Original Message -
From: Alex Speed [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 19, 2002 12:13 AM
Subject: SubSelect Problem
SELECT textid, title, description
Subject: SubSelect Problem
SELECT textid, title, description from structure where textid in (select
subtopicid from subtopic where topicid='Top');
Off the top of my head:
SELECT DISTINCT st.textid, st.title, st.description
FROM structure st INNER JOIN subtopic su
12 matches
Mail list logo