I am trying to write a query for multiple criteria in the query. Can someone please tell me what I am doing wrong?
SELECT Deviations_Request.AppId, Deviations_Request.AppName, Deviations_Request.Datastdname, Deviations_Request.Devreqsubmitted, Deviations_Request.Nonadoptcomment, Deviations_Request.Nonadoptreasondesc, Deviations_Request.[Final OA Comment],
IIF([Deviations_Request.Nonadoptcomment] = "Taiwan is non GC country, DQIP is not in scope for Taiwan"
Or [Deviations_Request.Nonadoptcomment] = "India is not GC and DQIP is not in scope as of now"
Or [Deviations_Request.Nonadoptcomment] = "Data Standard adoption will happen along with Global Common migration. As of now there is no
confirmed plan available for GC migration and should be reviewed start of next year for any change."
Or [Deviations_Request.Nonadoptcomment] = "will be the part of G2C program."
Or [Deviations_Request.Nonadoptcomment] = "Will adopt once DQIP is capable on this standard."
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned with Global Common"
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned for future GC release"
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned with GC v2"
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned with future GC release"
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned with GC v2. 07-Jun-2012: Arch team: User Maintainable based on RMR. System shall be enhanced to pass this information in all the upstream and downstream interfaces.ISO 2 byte numeric to be used as standard. Part of V7 scope"
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned with GC v2. 07-Jun-2012: Arch team: Business maintained in ""Security subtype"" for SB and ""Product classification"" for MF. Data to be passed to DWH. No additional adoption is required,"
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned with GC v2. 07-Jun-2012: Arch team: Lookup from RM. System shall be enhanced to capture the GOC code in addition to custoemr RC from RM and pass it to downstream interfaces.Part of V7 scope"
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned with GC v2. 07-Jun-2012: Disc with Arch team: Pass through. Adoption is based on the source provided PRS Data to be passed to DWH. Planned with SEA NWO APBC11070347"
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned with GC v2. 20-Jul-2012: Adoption planed for V7, pending V7 budget approve"
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned with GC v2. 6-7-12: Discussion with Architecture team: User Maintained based on RMR. System shall be enhanced to pass this information in all the upstream/downstream interfaces. 3 byte Char to be used as standard
Part of V7 scope"
Or [Deviations_Request.Nonadoptcomment] = "Data Standard adoption will happen along with Global Common migration. As of now there is no
confirmed plan available for GC migration and should be reviewed start of next year for any change", "DQIP", ",
IIF([Deviations_Request.Nonadoptcomment] = "Citiplanner to get feed from RM before sending the same to downstream systems.", "CITI", "")) AS Information_Column
FROM Deviations_Request
GROUP BY Deviations_Request.AppId, Deviations_Request.AppName, Deviations_Request.Datastdname, Deviations_Request.Devreqsubmitted, Deviations_Request.Nonadoptcomment, Deviations_Request.Nonadoptreasondesc, Deviations_Request.[Final OA Comment], Deviations_Request.Information;
SELECT Deviations_Request.AppId, Deviations_Request.AppName, Deviations_Request.Datastdname, Deviations_Request.Devreqsubmitted, Deviations_Request.Nonadoptcomment, Deviations_Request.Nonadoptreasondesc, Deviations_Request.[Final OA Comment],
IIF([Deviations_Request.Nonadoptcomment] = "Taiwan is non GC country, DQIP is not in scope for Taiwan"
Or [Deviations_Request.Nonadoptcomment] = "India is not GC and DQIP is not in scope as of now"
Or [Deviations_Request.Nonadoptcomment] = "Data Standard adoption will happen along with Global Common migration. As of now there is no
confirmed plan available for GC migration and should be reviewed start of next year for any change."
Or [Deviations_Request.Nonadoptcomment] = "will be the part of G2C program."
Or [Deviations_Request.Nonadoptcomment] = "Will adopt once DQIP is capable on this standard."
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned with Global Common"
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned for future GC release"
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned with GC v2"
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned with future GC release"
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned with GC v2. 07-Jun-2012: Arch team: User Maintainable based on RMR. System shall be enhanced to pass this information in all the upstream and downstream interfaces.ISO 2 byte numeric to be used as standard. Part of V7 scope"
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned with GC v2. 07-Jun-2012: Arch team: Business maintained in ""Security subtype"" for SB and ""Product classification"" for MF. Data to be passed to DWH. No additional adoption is required,"
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned with GC v2. 07-Jun-2012: Arch team: Lookup from RM. System shall be enhanced to capture the GOC code in addition to custoemr RC from RM and pass it to downstream interfaces.Part of V7 scope"
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned with GC v2. 07-Jun-2012: Disc with Arch team: Pass through. Adoption is based on the source provided PRS Data to be passed to DWH. Planned with SEA NWO APBC11070347"
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned with GC v2. 20-Jul-2012: Adoption planed for V7, pending V7 budget approve"
Or [Deviations_Request.Nonadoptcomment] = "Adoption planned with GC v2. 6-7-12: Discussion with Architecture team: User Maintained based on RMR. System shall be enhanced to pass this information in all the upstream/downstream interfaces. 3 byte Char to be used as standard
Part of V7 scope"
Or [Deviations_Request.Nonadoptcomment] = "Data Standard adoption will happen along with Global Common migration. As of now there is no
confirmed plan available for GC migration and should be reviewed start of next year for any change", "DQIP", ",
IIF([Deviations_Request.Nonadoptcomment] = "Citiplanner to get feed from RM before sending the same to downstream systems.", "CITI", "")) AS Information_Column
FROM Deviations_Request
GROUP BY Deviations_Request.AppId, Deviations_Request.AppName, Deviations_Request.Datastdname, Deviations_Request.Devreqsubmitted, Deviations_Request.Nonadoptcomment, Deviations_Request.Nonadoptreasondesc, Deviations_Request.[Final OA Comment], Deviations_Request.Information;