Re: How to delete from only one side of a join?

2003-02-17 Thread Paul DuBois
At 9:32 -0600 2/17/03, Mayo, Chuck wrote: Hi all, Just jumped on the list, hoping someone can give me a hand. The query below uses a join, I guess, to select records from table stat_1_1 based on information in table stat. I'd like to be able to turn this query into a delete query but only want re

Re: How to delete from only one side of a join?

2003-02-17 Thread Paul DuBois
At 9:32 -0600 2/17/03, Mayo, Chuck wrote: Hi all, Just jumped on the list, hoping someone can give me a hand. The query below uses a join, I guess, to select records from table stat_1_1 based on information in table stat. I'd like to be able to turn this query into a delete query but only want re

How to delete from only one side of a join?

2003-02-17 Thread Mayo, Chuck
Hi all, Just jumped on the list, hoping someone can give me a hand. The query below uses a join, I guess, to select records from table stat_1_1 based on information in table stat. I'd like to be able to turn this query into a delete query but only want records removed from stat_1_1. Can anyone tel