DELETE FROM FolioRestResTableChairsXTab WHERE FolioNumber IS NULL OR FolioNumber<=0 OR RestaurantReservationNumber IS NULL OR RestaurantReservationNumber <=0
DELETE FROM RestaurantReservations WHERE RestaurantReservationNumber IS NULL OR RestaurantReservationNumber <=0
DELETE FROM Folios WHERE FolioNumber IS NULL OR FolioNumber<=0 AND (
  SELECT TOP 1 Transactions.FolioNumber FROM Transactions WITH (NOLOCK) WHERE Transactions.FolioNumber= Folios.FolioNumber) IS NULL 

