Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. chillam

    Multiple field values in a single group

    LB, Thanks for your response. Unfortunately, Union is not permitted using AR System ODBC Driver.
  2. chillam

    Multiple field values in a single group

    Hi, I will be using this report in 'Remedy Applications', where the connection to the Oracle DB is done using 'AR System ODBC Connector'. As mentioned initially, these engineer (like Joe, Ben...) can be under 'Engineer1/ Engineer2/ Engineer3/ Engineer4'. They are not restricted to one...
  3. chillam

    Multiple field values in a single group

    Hello LB, Thnks again for your reply.... Here is the SQL Query. We are connecting to Oracle database using 'AR System ODBC Connector'. SELECT "WorkOrder"."Work_Order_ID_", "WorkOrder"."Total_Cost", "WorkOrder"."Create_Date", "WorkOrder"."Category", "WorkOrder"."Request_Type"...
  4. chillam

    Multiple field values in a single group

    LB, Thanks for your reply. When i use the above mentioned process in performing the union in the command, am getting error "lexical element not found". There are other fields in the table too, that have to be displayed, which are like start date, end date...these fields are not multiples as...
  5. chillam

    Multiple field values in a single group

    Yes. Each record have multiple Names. Thanks,
  6. chillam

    Multiple field values in a single group

    Hi, I am having trouble grouping multiple field data in a single group. I have a table as below: Name1 Cost1 Name2 Cost2 Name3 Cost3 Joe $5.00 Ben $4.50 Bob $6.75 Ben $8.00 Jane $3.00 Joe $11.15 Mike $32.00 Bob $9.32...

Part and Inventory Search

Back
Top