How to use Not exist join with Update_recordset

(1) Share

Report

Posted on by Mohammed Raziq Ali

Can we use notexist join with update_recordset? Is it feasible?

Regards,

Raziq

I have the same question (0)

All responses (6)

Answers (2)

Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Raziq,

Did it you try it? Or do you have a code that you tried?

Thanks,

Layan Jweihan

Was this reply helpful? Yes No
Mohammed Raziq Ali 4 on at

Like (0)

Report
Copy link

Link copied!

I tried with notexist join but it didn't work.

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yes, you can use not exist join. It should work. Can you please send your code? Also did you check the same in SQL? May be if there are records existing with given condition so it did not work.

Was this reply helpful? Yes No
Verified answer

Judy Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi,

I think it should possible. Have you tried with the X++ SQL in the below blog, I am not sure if it can help since it very old.

https://amannain.blogspot.com/2014/04/using-updaterecordset-with-views.html

Have you tried these X++ SQL Statement with where sub-statement:

CustTable custTable;
ttsBegin;
update_recordset custTable
setting CreditMax = 5000
where not exists (select * from otherTable)
........
ttsCommit;

Best Regards,

Judy

Was this reply helpful? Yes No
Verified answer

Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi Mohammed,

I just tried it and it works perfectly fine.
CustTable custTable; SalesTable salestTable; update_recordset custTable setting accountstatement = 1 where custTable.DataAreaId == 'AA' notexists join salestTable where salestTable.CustAccount == custTable.AccountNum && salestTable.DataAreaId == 'AA';

Thanks,
Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No
Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Do you still need help with this? If not then please verify the answers that helped you.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to use Not exist join with Update_recordset

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the January Top 10 Community Leaders

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to use Not exist join with Update_recordset

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the January Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates