Deleting records from joined tables

Results 1 to 2 of 2

Thread: Deleting records from joined tables

  1. #1
    Queriƫn Guest

    Default Deleting records from joined tables

    I&#039d like to know how to delete records from two joined tables.<BR>For example I&#039ve a table Employer and a table Vacancies they are Innerjoined on Emp_ID which is an autonumber in Employer so I cannot enforce referential integrety because the field types are not the same.(Autonumber and Number)<BR>But when i delete a Employer I want his vacancies deleted too.<BR>Can I do this in one SQL statement?<BR>please email me if you have an answer.<BR>Thanks, Querien

  2. #2
    ActiveALLI Guest

    Default RE: Deleting records from joined tables

    Are you doing this in Access ??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •