The first SQL code below is in an existing db's queries. What I'm wondering is why [Main].[Hospital] is in there 3 times? Wouldn't once be sufficient? The full table with all hospitals (3 of them) gets imported into a new db, then all data except for 1 get deleted. Wouldn't the second code do the same thing?
VB Code:
  1. DELETE [Main].[Hospital] AS Expr1, [Main].[Hospital] AS Expr2, [Main].[Hospital] AS Expr3
  2. FROM Main
  3. WHERE ((([Main].[Hospital])<>[Which Hospital?]));
VB Code:
  1. DELETE Hospital as Expr1 FROM Main WHERE Hospital <> [Which Hospital?]