Again thanks all for help before Now hopefully for an easier questions: In ACCESS my query looks like: 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, when I do this with the above query, I get the error message: Incorrect syntax near ',' How do you delete from more than one table at a time with SQL? 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
