Hi list, does MySQL accept a SELECT inside another SELECT, like this:
SELECT t.Trial_ID_Code AS Trial, CONCAT(s.Site_Primary_Investigator_Title, " ", s.Site_Primary_Investigator_Last_Name) AS 'Investigator', CONCAT(sc.Site_ID_Number, "-", s.Site_ID_Code, "-", sc.Scanner_ID_Number) AS Site, sc.Scan_Subject_ID AS 'SubjectInitials', sc.Scan_Screening_ID AS 'ScreeningNumber', tp.TimePoint_Code AS 'TimePoint', sc.Scan_Acquired_On AS 'ScanAcquiredOn', IF(sc.QCResult_ID_Number = 2, 'Passed', 'Faild') AS 'QCResult', IF(sc.Scan_Screening_Result='n', 'Failed', 'Passed') AS 'GDScreeningResult' (SELECT Scan_Screening_Result FROM ScanQuantification WHERE sc.Trial_ID_Number = Trial_ID_Number AND sc.Site_ID_Number = Site_ID_Number AND sc.Scanner_ID_Number = Scanner_ID_Number AND sc.Scan_ID_Number = Scan_ID_Number AND sq.Quantification_ID_Number = 1 AND ProcessType_ID_Number = 5) AS 'GDScreeningValue' FROM Scan sc, Trial t, Site s, TimePoint tp WHERE sc.Trial_ID_Number = t.Trial_ID_Number AND sc.Site_ID_Number = s.Site_ID_Number AND sc.TimePoint_ID_Number = tp.TimePoint_ID_Number AND sc.TimePoint_ID_Number = 8 AND (sc.Scan_Receipt_On >= '2004-05-10' AND sc.Scan_Receipt_On <= '2004-05-14') AND sc.QCResult_ID_Number > 1 ORDER BY sc.Site_ID_Number Thanks. Andre -- Andre Matos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]