WHERE condition: It is used to specify the conditions to filter records.It can be a pair of primary and foreign keys. ON t1.column_name = t2.column_name: It is used to specify the common conditions on which the two tables will be joined. To join, you may choose from INNER, LEFT, FULL and RIGHT joins. Here, table_name1 is the name of the left table and table_name2 is the name of the right table. FROM table_name1 as t1 JOIN table_name2 as t2: It is used to specify the source from which data has to be fetched and deleted.Here, you may choose from the first table’s instance t1 and the second table’s instance t2. DELETE t1: It is used to delete the required table from the database.The different parameters used in the syntax are: The basic syntax for Delete Join in SQL Server is as follows:įROM table_name1 AS t1 JOIN table_name1 AS t2 Hadoop, Data Science, Statistics & others
0 Comments
Leave a Reply. |