UPDATE

[cards4]

Hello,
I need to update 3 columns on a table with new data. However, when I try to update the table with this query:
update phbasic set emp_id='???', empno='???', soc_sec_no='????'
where emp_id='???', empno='???', soc_sec_no='???'
It gives me an error.

I haven't done much SQL work dealing with UPDATE. Please help. Thank you.

The ??? represent data and is not in my acutal query.

 

[AlexCuse]

Hi Cards,

where emp_id='???', empno='???', soc_sec_no='???'

should be

where emp_id = '???' [b]AND[/b] empno = '???' [b]AND[/b] soc_sec_no = '???'

Hope this helps,

Alex

It's a magical time of year in Philadelphia. Eagles training camp marks the end of another brutal season of complaining about the Phillies.

 

[cards4]

Thank you very much.