That syntax isn’t valid in Oracle. You can do this: Or you might be able to do this: It depends if the inline view is considered updateable by Oracle ( To be updatable for the second statement depends on some rules listed here ).
You need to specify what table you are deleting from. Here is a version with an alias:
They are functionally equivalent, but INNER JOIN can be a bit clearer to read, especially if the query has other join types (i.e. LEFT or RIGHT or CROSS) included in it.
Reading this original article on The Code Project will help you a lot: Visual Representation of SQL Joins. Also check this post: SQL SERVER – Better Performance – LEFT JOIN or NOT IN?. Find original one at: Difference between JOIN and OUTER JOIN in MySQL.
You can do the following (I guessed on table fields,etc) Based on your request for multiple halls you could do it this way. You just join on your Hall table multiple times for each room pref id:
Assuming you’re joining on columns with no duplicates, which is a very common case: An inner join of A and B gives the result of A intersect B, i.e. the inner part of a Venn diagram intersection. An outer join of A and B gives the results of A union B, i.e. the outer parts of a … Read more
Assuming you’re joining on columns with no duplicates, which is a very common case: An inner join of A and B gives the result of A intersect B, i.e. the inner part of a Venn diagram intersection. An outer join of A and B gives the results of A union B, i.e. the outer parts of a … Read more