Update subselect subquery

  • Thread starter Thread starter Randy Walker
  • Start date Start date
R

Randy Walker

I can't seem to figure out another way of doing this in ONE query. Anybody
got any hints?

update tblLoadControl set rec_count = (select count(*) from
Export_MajorZone) where load_id = 1

Randy Walker
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SubSelect in A97 7
Update Current Row based on Previous Row 9
Can a Table be Updated From a Subquery with Aggregate Count Value? 6
can i make this query updatable 2
Update Statement with SubSelects 3
Problem with Dual subselect 7
Referring to fields in a subquery 1
nested subselects with exists 2

Back
Top