Join forms have a specific form type. I think its 2. Find all forms with that type and fields in them. Field names would be in the fields tables and form names from the arschema table. A simple query to the arschema table should give you all the join forms and then a nested query to the fields table should give you all your fields and their ID's
Joe _____ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Raj Sent: Monday, March 11, 2013 2:42 PM To: arslist@ARSLIST.ORG Subject: Query to find Joined Columns/fields & tables/forms ** Hello All, We are working on archiving strategy. In that process, to make the DB Script automated but not hard coded, trying to figure out a SQL query to find list of all the fields and the forms exists in JOIN forms. Trying something like below: select queryshort from schema_join where schemaid=3128 result: 4\1\99\536870913\1\1\ >From the example above, (Column/field)536870913 from Form A is joined with (Column/Field)1 from Form B. Wanted to check with DB Experts in here to figure out a query to find joined columns/fields, tables/forms we have in JOINED forms on our system. We have over 100 JOIN forms, so thought Query would be way faster than manually opening each form and identifying the forms and fields. Please advise. Regards, Raj _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"