|
Posted by Ed Murphy on 11/30/06 10:03
othellomy@yahoo.com wrote:
> Delete Appointment a
> Where exists (select 'hi there'
> From Entity e
> Where a.attendee = e. attendee
> Group by e. attendee
> Having count(e. attendee) <= 1)
A_Appointment doesn't have an 'attendee' column. Original post: "One
appointment may have multiple attendees (Appointment_Entity)".
Reworking this to use AX_Appointment_Entity (and to change 'delete' to
'delete from') ought to lead to another valid solution.
Navigation:
[Reply to this message]
|