Click here to Skip to main content


GeneralRe: Fault Exception in WCF Services PinmemberPhanindra26114-Nov-12 8:05 
QuestionRelation multiple table using in C# PinmemberYBG13-Nov-12 2:53 
AnswerRe: Relation multiple table using in C# PinmemberPhanindra26114-Nov-12 8:23 
QuestionTrying to get a MySQL subquery to return multiple records PinmemberSQL Ed12-Nov-12 8:19 
The following subquery returns 1024 records with a single count column. I am trying to return multiple columns with 1024 records. When I make changes to return multiple columns I get 17,000 records instead of 1024 records. I have very litle experience with subqueries. Does anyone have any suggestions?
SELECT IFNULL(COUNT(DISTINCT A.computerid),0) AS 'Machine Count',
A.hotfixID AS 'Last Contact'
FROM (SELECT HF.computerid, HF.hotfixID
FROM hotfixdata HFD

ON HF.hotfixid = HFD.hotfixid
AND HFD.ignore <> 1
ON C.ComputerID=HF.ComputerID

WHERE INSTR(C.os,"microsoft")>0
AND HF.installed <> 1
AND HF.Approved = 1
GROUP BY HF.hotfixID, HF.ComputerID) A;
AnswerRe: Trying to get a MySQL subquery to return multiple records PinmemberEddy Vluggen12-Nov-12 11:33 
QuestionSending data to database PinmemberPhanindra26111-Nov-12 19:03 
AnswerRe: Sending data to database Pinmemberjschell12-Nov-12 10:08 
AnswerRe: Sending data to database PinmemberMycroft Holmes12-Nov-12 12:51 
GeneralRe: Sending data to database PinmemberPhanindra26113-Nov-12 18:40 
QuestionHow to create reports effectively [modified] PinmemberFrygreen9-Nov-12 0:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 29 Jul 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid