Bala, I think that it would be something like this:
Select name,fieldid from field where schemaid = (select * from arschema where name = "HPD:Help Desk") Thanks Kelly Gatewood Senior Solutions Architect IT Prophets Cell 615-830-5078 www.itprophets.com<http://www.itprophets.com> From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Bala Patel Sent: Thursday, July 23, 2009 12:44 PM To: [email protected] Subject: Print Field and Fields ** Hi List, Does anyone know how to perform a SQL statement to get the column names and field id's for a form in Remedy? Thanks, Bala Patel ARS 7.03 _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
