I don't think you can delete from more than one table at a time. If you wanted to do it in one call from CF you could do it in a stored proc. Or you could set up a trigger to delete from one table when related records were deleted from another. -----Original Message----- From: Bruce, Rodney [mailto:[EMAIL PROTECTED]] Sent: 08 June 2001 21:24 To: CF-Talk Subject: OT: Convert ACCESS query to SQL query Need a little help with this, just learning SQL server and am trying to convert over from ACCESS. In ACCESS my query looks like: DELETE table1.*, table2.* FROM table1 LEFT JOIN table2 ON table1.field= table2.field WHERE table1.field = variable; and works fine but removing *s does not work. works if only deleting from one table. DELETE table1, table2 FROM table1 LEFT JOIN table2 ON table1.field= table2.field WHERE table1.field = variable; IN SQL when deleting, the *s are left out, I get this to work fine when only deleting from one table, I get the error message, when I remove the *s: Incorrect syntax near ',' How do you delete from more than one table at a time with SQL? I can get around this by changing to 2 queries: 1) del records in table 1 based on variable 2) del records in table 2 based on variable but I should be able to keep in one query, similar to the one used for ACCESS. some help please Rodney ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
