Select mit Subselect Problem

2007-12-17 Thread Marcus Füg
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

Re: Select mit Subselect Problem

2007-12-17 Thread Kevin Hunter
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

Subselect Problem

2003-11-17 Thread Peter J. Krawetzky
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

Re: Subselect Problem

2003-11-17 Thread Paul DuBois
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

Re:count in subselect problem

2003-01-25 Thread Nasser Ossareh
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

count in subselect problem

2003-01-24 Thread Stijn Van Rompaey
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

SubSelect Problem

2002-03-18 Thread Alex Speed
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

RE: SubSelect Problem

2002-03-18 Thread Dan Vande More
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

RE: SubSelect Problem

2002-03-18 Thread Eric Mayers
, 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

RE: SubSelect Problem

2002-03-18 Thread Gurhan Ozen
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

Re: SubSelect Problem

2002-03-18 Thread Alex Speed
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

Re: SubSelect Problem

2002-03-18 Thread Bob Hall
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