Hi, i have a table of donors which are divided into new and repeat donors.
i have the query for getting all donors and the query of getting all new donors.
how do i get the repeat donors?
i need to get the yellow part.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Answer by Kev Riley · Dec 21, 2020 at 11:28 AM
Without knowing the structure, the simplest psuedo-query would be
select ...columns..... from table where key not in (select key from white-part query)
Answers Answers and Comments
15 People are following this question.
how to use join with old kind (+) in SQL server
How to avoid duplicates in XML while inserting into SQL Table
How to automate backup of sqlexpress
Need help with Trigger Function
I Need Duration Column in Order 8am-9am,9am-10am...5pm-6pm