Kathy,

Is this about the RE:Job Runs form?

Use ARSystem to do the delete. It will clean up H and B tables for you. Did you 
create the filter to do the delete?

Are you having an issue deleting the RE:Job runs records?

Regards,
Ryan.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris
Sent: Thursday, August 15, 2013 10:26 AM
To: arslist@ARSLIST.ORG
Subject: SQL Query

**
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.





_ARSlist: "Where the Answers Are" and have been for 20 years_

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Reply via email to