Hi all,
Is it possible to perform delete operation with the table join like
this?

'DELETE FROM temp INNER JOIN request_tbl ON temp.ID = request_tbl.ID
WHERE temp.name LIKE request_tbl.name;'

On May 14, 1:53 am, cmem... (AT) gmail (DOT) com wrote:
Think about it for a moment. What do you get when you write:
temp INNER JOIN request_tbl ON temp.ID = request_tbl.ID
?
You no longer have a table you have a result set. Given that, what do
you think is the target of the DELETE?

Syntax of DELETE is

DELETE FROM <table name>
WHERE <predicate>

ASSUMING the temp table is the target of the delete something like
this works:
DELETE FROM temp where temp.ID IN
( select temp.ID FROM temp INNER JOIN request_tbl ON temp.ID =
request_tbl.ID
WHERE temp.name LIKE request_tbl.name ) ;

Have a good day,
Ed

On May 14, 1:53 am, cmem... (AT) gmail (DOT) com wrote:
Think about it for a moment. What do you get when you write:
temp INNER JOIN request_tbl ON temp.ID = request_tbl.ID
?
You no longer have a table you have a result set. Given that, what do
you think is the target of the DELETE?

Syntax of DELETE is

DELETE FROM <table name>
WHERE <predicate>

ASSUMING the temp table is the target of the delete something like
this works:
DELETE FROM temp where temp.ID IN
( select temp.ID FROM temp INNER JOIN request_tbl ON temp.ID =
request_tbl.ID
WHERE temp.name LIKE request_tbl.name ) ;

Have a good day,
Ed

On May 14, 1:53 am, cmem... (AT) gmail (DOT) com wrote:
Think about it for a moment. What do you get when you write:
temp INNER JOIN request_tbl ON temp.ID = request_tbl.ID
?
You no longer have a table you have a result set. Given that, what do
you think is the target of the DELETE?

Syntax of DELETE is

DELETE FROM <table name>
WHERE <predicate>

ASSUMING the temp table is the target of the delete something like
this works:
DELETE FROM temp where temp.ID IN
( select temp.ID FROM temp INNER JOIN request_tbl ON temp.ID =
request_tbl.ID
WHERE temp.name LIKE request_tbl.name ) ;

Have a good day,
Ed