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

Popular posts from this blog

IF statement in MySQL trigger -

c++ - What does MSC in "// appease MSC" comments mean? -

javascript - Blogger related post gadget image Resize s72-c [ Need Expert Help ] -