How do I delete attributes using join condition in SQL and add to oledb command

Question

1.44/5 (2 votes)

See more:

I need to update the oledb command in order to delete the entire record involved in two tables using Inner Join condition

What I have tried:

C#

"DELETE FROM InvoiceNumber,INVOICENO from InvoiceItems WHERE InvoiceItems.InvoiceNumber=TAXINVOICE.INVOICENO and InvoiceNumber=" + txtInvoice.ToString() + ""

Posted 16-Oct-16 22:56pm

Member 12790908

Updated 16-Oct-16 23:40pm

Suvendu Shekhar Giri

v3

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

BrishPandey · Answer 1 · 2016-10-16T23:27:00

Solution 1

You can use sub query that will return the list of id that satisfy the condition of your join.
and in where clause of delete you should use 'in' keyword for filtering

Posted 16-Oct-16 23:27pm

BrishPandey

Suvendu Shekhar Giri · Answer 2 · 2016-10-16T23:40:00

If you want to remove records from both tables - InvoiceItems and TAXINVOICE then try using INNER JOIN, something like following-

C#

"DELETE InvoiceNumber,TAXINVOICE FROM InvoiceItems INNER JOIN TAXINVOICE WHERE InvoiceItems.InvoiceNumber=TAXINVOICE.INVOICENO and InvoiceNumber=" + txtInvoice.Text

Note: Have changed txtInvoice.ToString() to txtInvoice.Text considering it to be a textbox

Please let me know if your requirement is different than this.
Hope, it helps :)

How do I delete attributes using join condition in SQL and add to oledb command

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How do I delete attributes using join condition in SQL and add to oledb command

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us