mysql-error-1241

Need help with mysql query.

So I am trying to do a somewhat complex query and am having trouble. I have structured it like this as it seems to be the most logical: SELECT (intake.id, s_matters.id, s_calls.cid, s_events.id) AS id, (intake.name, s_matters.casename, s_calls.name, s_events.subject) AS title FROM intake, s_matters, s_calls, s_events WHERE tit...

How to select and update a record at the same time in mySQL?

Is there any way to select a record and update it in a single query? I tried this: UPDATE arrc_Voucher SET ActivatedDT = now() WHERE (SELECT VoucherNbr, VoucherID FROM arrc_Voucher WHERE ActivatedDT IS NULL AND BalanceInit IS NULL AND TypeFlag = 'V' LIMIT 1 ) which I hoped would run the...