Something like this?

Update users

Set deleted = '1'

from users u

join UserStatus us on u.username = us.username

where us.status = 'inactive'

Presumably you want to send this to the front end? What language? This is usually pretty simple.

Is this a one time thing??? I created a script several years ago to do just this sort of thing but it is 100% **cough** cursor **cough** based. It was...

This is because there is no record where name = '(''Name1'',''Name2'')'

You can't use a single variable like that. You will have to split this variable first. You should check out...

If we do your homework for you, you don't learn anything. You need to at the very least try this yourself.

This is the same as your previous post. Please direct all replies here

The access form would still be the front end. You would change the forms to use sql server instead of access as the db.

If you want help figuring it out post some ddl and some sample data and we can give it a whirl.

So there is a field in each record of the Journal table that tells you which table name to join to?? This is what I have been suspecting all along....

I tried the following code before and it works fine except that I need to supply the @jtName variable dynamically inline the query.

DECLARE @jtName nvarchar(max);

DECLARE @qry nvarchar(max);

SET @jtName = '0c183530-9a0b-447b-8bf5-ac5b2ed36231';

SET...

I suspect that dynamic sql is the only way you are going to have a chance. If you can post some ddl and sample data along with desired output we...

Glad you found a working solution. 😀

This sounds like a really strange requirement. Do you have a column in your first table that tells you which table the additional information is stored? Are you planning on...

Please don't create new posts to continue a topic. it just fragments discussions and makes it harder for other to learn from the solution. As you stated please direct all...

You know all the people who answer question on these forums are volunteers. You provided little of the information needed for someone to be able to help you. You have...