sql server - SQL WHERE Statement With Multiple Account Numbers -
i'm working sql query , need display set of information, have 5 records display. following query isn't working:
select m.customer_number, m.last_name, m.billing_address_line_1, m.billing_address_line_2, m.billing_city, m.billing_state, m.phone_number1, c.equipment_serial_no, c.make, c.model_number, c.color_code customer_master m inner join equip_master c on m.customer_number = c.customer_number m.customer_number = '19975107' , '1039283' , '39203821' , '23824917' , '1833729' i following error:
msg 4145, level 15, state 1, line 9 expression of non-boolean type specified in context condition expected, near '19978107'
that's not valid syntax. if want list of customer_number use in clause.
.... m.customer_number in('19975107', '1039283', '39203821' ,'23824917' , '1833729')
Comments
Post a Comment