delete details from details inner join master on details.keyid=master.ke

How to write query to Delete the records in child table
and corresponding records in parent table

Question Posted / sanjay

Answer Posted / sanjay

delete details from details inner join master on
details.keyid=master.keyid

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

mention different types of relationships in the dbms?

1088

How to edit table in sql server 2017?

979

Why I can not enter 0.001 second in date and time literals in ms sql server?

1106

what stored procedure can you use to display the current processes? : Sql server administration

1056

Define inner join? Explain with an example?

1047

What command do we use to rename a database?

1116

What are the key configuration files for sql server reporting services ?

171

How do I create a trace in sql server?

1090

What is the name of reporting services config file and what’s it’s used for?

153

What is use of except clause?

1140

What are subqueries in sql server?

1192

How to drop existing indexes in ms sql server?

1130

Explain about analysis services?

1104

What is the exact numeric data type in sql?

1056

What are window functions in sql server?

1066