Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Delete from Joi...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 15950 of 17437
Post > Topic >>

Delete from Join

by postgres@[EMAIL PROTECTED] (Gwyneth Morrison) Jul 2, 2008 at 11:15 AM

Hello,

Is it possible to use a join keyword in a delete?

For example:

     DELETE FROM data_table1
                using data_table2 INNER JOIN
                        data_table1  ON data_table1.fkey =
data_table2.pkey;


It is not directly mentioned in the delete syntax but the delete refers 
to the select clause where JOIN is valid.

G
              

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 1 Posts in Topic:
Delete from Join
postgres@[EMAIL PROTECTED  2008-07-02 11:15:41 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 16:06:42 CST 2008.