Posted by Brian Link on 11/30/06 04:32

Panicked, as usual. Who says it's great being a sole proprietor?

Using MS-SQLServer:

Three tables: A_Appointment, AX_Appointment_Entity and E_Entity.
AX_Appointment_Entity is an intersect/association table between
A_Appointment and E_Entity. One appointment may have many attendees
(Appointment_Entity). One attendee (Entity) may have many
appointments.

My task is to delete all appointments and related
AX_Appointment_Entity rows where the number of attendees is one or
less.

I'm great at standard select or delete queries. Because this straddles
tables in a way I'm less skilled in, I'm pleading for help.

Thanks for any ideas. fwiw, I'm using Transact-SQL.

BLink
--------------------------
"The worst thing about censorship is [redacted]"

• Next in forum: MI5 Persecution: Counter-surveillance sweep by Nationwide Investigations Group
• Prev in forum: How to import from external SQL database to local SQL database
• Thread view: Need Emergency Help with SQL Query (difficulty: moderate)

[Reply to this message]