[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 557
  • Last Modified:

Sybase Update Query Help

I have 3 tables:
Profl with fields: id, eventcode, parent
Usr with 2 fields: id, rolename
Roac with 3 fields: eventcode, rolename, parent

I need a query that will update the parent field from the Profl table with the value from the parent field from the Roac table based on the rolenames matching (from Roac and Usr) and the ids matching from the Profl and Usr tables.

Am I able to do this with an update statement? I know I can do it with a stored proc but want more of a 'quick and dirty'.

Thanks.
0
pmacmann
Asked:
pmacmann
  • 2
1 Solution
 
amitpagarwalCommented:

update Profl
set parent = R.parent
from Profl P,
Usr U,
Roac R
WHERE P.id = U.id
and U.rolename = R.rolename

hope this helps.
0
 
amitpagarwalCommented:
pmacmann,

any updates on this query ??
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now