insert subquery

[DJ]

i want to insert a row into table1 only if the value being inserted on 
table1 exists on table2 primary id.

can i do this with subquery?
thanx.


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.5/110 - Release Date: 9/22/2005


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]