Hi,
I am trying to remove specific records from a table (T350). If I run a SQL query on a Remedy form that has a T-table (T350) with a B-table (B350) attachments, Am I going to be able to delete the data in both tables? My query: Select C8 from T350 Where C8 = 'Reconciliation' My concern is. how am I going to delete the records in the B-table that are associated with the records from the T table? The Column C8 does not exist in the B350 table so I cannot write. Select C8 from B350 Where C8 = 'Reconciliation' ----- C8 does not exist in the B table. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"