select vendor_id, vendor_name, (vendormallcommissions_level1percent * vendormallcommissions_payoutpercent / 100) as 'Cash Back' from vendor inner join vendormallcommissions on vendor_id = vendormallcommissions_vendorid where vendormallcommissions_compplanplid = and vendormallcommissions_bpercentorcash = 1 and vendor_id in (5, 23, 1156, 33, 35, 40, 56, 65, 67, 75, 106, 130, 154, 159, 171, 2638, 2644, 2646, 2667, 2668, 2756, 2773, 2775, 2778, 2758, 2772, 2776, 2584, 2642, 2645, 2656, 2661, 2665, 2666, 2669, 2509, 2648, 2651, 2600, 2601, 2602, 2652, 2603, 2604, 2607, 2609, 2617, 2647, 2649, 2658, 2671, 2673, 2675, 2677, 2679, 2680, 2682, 2683, 2587, 2588, 191, 205, 2322, 1818, 1820, 1821, 1825, 1826, 1827, 1832, 1833, 1834, 1836, 1837, 1839, 1840, 1844, 1847, 1848, 1850, 1853, 1855, 1859, 1861, 1866, 1867, 1871, 1932, 1901, 1902, 1903, 1904, 1905, 1907, 1912, 1920, 1922, 1927, 1928, 1934, 2033, 2158, 2182, 2194, 2197, 2198, 1945, 1946, 1948, 1953, 1954, 1961, 1962, 1964, 1966, 1971, 1972, 1975, 1976, 1977, 1978, 1980, 1985, 1994, 1996, 2001, 2002, 2004, 2009, 2011, 2013, 2019, 2024, 2030, 2031, 2035, 2037, 2045, 2048, 2049, 2051, 2054, 2058, 1702, 1711, 1747, 1750, 1751, 1759, 1771, 1776, 1778, 1780, 1781, 1786, 1791, 1797, 1807, 226, 229, 246, 700, 710, 711, 712, 715, 724, 726, 727, 749, 755, 758, 759, 761, 762, 765, 772, 776, 777, 784, 786, 788, 793, 794, 806, 809, 814, 815, 816, 829, 833, 834, 835, 837, 861, 863, 867, 869, 873, 881, 882, 883, 1016, 1033, 892, 895, 897, 1046, 905, 911, 917, 931, 954, 958, 982, 983, 988, 998, 1001, 1011, 1012, 1013, 1015, 1028, 1038, 294, 312, 342, 355, 367, 324, 344, 354, 366, 411, 420, 421, 422, 426, 429, 431, 434, 513, 514, 458, 459, 461, 465, 481, 489, 495, 497, 696, 654, 732, 800, 852, 526, 532, 533, 535, 538, 542, 571, 573, 595, 864, 874, 875, 878, 622, 634, 636, 638, 645, 653, 658, 660, 661, 664, 668, 670, 672, 689, 692, 693, 1062, 1128, 1167, 1169, 1182, 1184, 1185, 1187, 1191, 1192, 1193, 1064, 1066, 1071, 1072, 1073, 1080, 1082, 1083, 1085, 1091, 1198, 1200, 1106, 1107, 1210, 1218, 1220, 1226, 1109, 1115, 1371, 1375, 1378, 1382, 1120, 1121, 1122, 1390, 1394, 1126, 1139, 1141, 1144, 1146, 1151, 1152, 1154, 1155, 1161, 1166, 1176, 1209, 1233, 1239, 1242, 1248, 1249, 1278, 1305, 1315, 1316, 1317, 1320, 1321, 1323, 1332, 1335, 1336, 1338, 1341, 1345, 1349, 1350, 1351, 1352, 1356, 1370, 1393, 1467, 1457, 1458, 1463, 1466, 1512, 1516, 1518, 1520, 1521, 1522, 1523, 1527, 1532, 1534, 1469, 1471, 1472, 1473, 1477, 1479, 1481, 1542, 1495, 1496, 1499, 1500, 1502, 1508, 1511, 1517, 1544, 1795, 1810, 1557, 1562, 1563, 1564, 1569, 1573, 1575, 1577, 1578, 1590, 1591, 1593, 1598, 1611, 1612, 1613, 1614, 1615, 1618, 1620, 1628, 1630, 1633, 1634, 1635, 1657, 1662, 1677, 1854, 1856, 1858, 1862, 1872, 1874, 1884, 1886, 1887, 1889, 1891, 1893, 2242, 2243, 2244, 2245, 2247, 2248, 2249, 2252, 2254, 2256, 2259, 2260, 2264, 2271, 2272, 2276, 2279, 2280, 2281, 2283, 2285, 2286, 2287, 2313, 2314, 2317, 2323, 2329, 2330, 2331, 2332, 2336, 2337, 2339, 2340, 2341, 2349, 2351, 2357, 2361, 2366, 2368, 2391, 2394, 2405, 2408, 2410, 2069, 2072, 2075, 2078, 2084, 2092, 2093, 2095, 2097, 2102, 2105, 2107, 2109, 2110, 2115, 2120, 2126, 2127, 2128, 2134, 2140, 2141, 2143, 2146, 2147, 2148, 2149, 2150, 2152, 2154, 2156, 2166, 2167, 2170, 2172, 2176, 2177, 2184, 2190, 2199, 2232, 2273, 2327, 2343, 2352, 2201, 2202, 2354, 2356, 2367, 2369, 2376, 2433, 2436, 2431, 2434, 2439, 2443, 2444, 2459, 2461, 2462, 2464, 2466, 2473, 2478, 2479, 2234, 2235, 2236, 2449, 2453, 2457, 2458, 2465, 2477, 2480, 2481, 2448, 2470, 2780, 2781, 3106, 3117, 3121, 3206, 3207, 3236, 3200, 2674, 2684, 2687, 2692, 2699, 2700, 2701, 2704, 2717, 2718, 2721, 2725, 2729, 2686, 2689, 2708, 2709, 2713, 2714, 2715, 2722, 2724, 2726, 2728, 2734, 2737, 2738, 2739, 2743, 2750, 2693, 2695, 2698, 2705, 2706, 2712, 2719, 2727, 2730, 2735, 2741, 2742, 2746, 2747, 2748, 2751, 2759, 2760, 2761, 2763, 2765, 2766, 2767, 2768, 2769, 2770, 2771, 2835, 2836, 2837, 2838, 2840, 3084, 3088, 3094, 2852, 2864, 2866, 2868, 2878, 2879, 2881, 2886, 2895, 2830, 2831, 2832, 2833, 2834, 2843, 2849, 2859, 2951, 2962, 2963, 2965, 2982, 2988, 2993, 3001, 3003, 2990, 3014, 3043, 3395, 3403, 2910, 2914, 2927, 2945, 2946, 2950, 2970, 2971, 2979, 2986, 2926, 2935, 2936, 2955, 2973, 2976, 3015)
[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keyword 'and'.
Alphabetical