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!

  • Congratulations IamaSherpa 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. tomadobro

    How to send a form on-line as a file using HTML

    I have a Word document form that I will be using on-line. An employee is supposed to fill out the form and hit the submit button. Once that is done, that form should be sent to me as an e-mail. Any one know what I could do to do this? Any help on this would be appreciated. Thanks!
  2. tomadobro

    Using '%' comparison in Crystal

    Does anyone know how to use the '%' in Crystal Reports? In SQL you can use this to search for a particular description through a field. An example would be; SELECT ITEM FROM INVENTORY WHERE ITEM LIKE '%BEARING%'; This query would than find any items with the word 'BEARING' in them and...
  3. tomadobro

    Can not join two tables using group and having functions

    Tim Thanks for all your help so far, but if you can believe, I'm still getting an error. Here it is: select inventory.catalogcode, item.description ^ Error: ORA-00904: invalid column name I checked and rechecked and the column names. They are valid. So, now I'm confused and frustrated...
  4. tomadobro

    Can not join two tables using group and having functions

    All right, I tried both statements and got errors. Most likely my fault. Let me give you the exact table information and give you a feel for what I'mm trying to do: select inventory.catalogcode, item.description from itasca.inventory, itasca.item group by catalogcode having count(*) > 1...
  5. tomadobro

    Can not join two tables using group and having functions

    I am trying to find duplicate items in a table. The problem is that the information I need is in more than 1 table. Example of code that works, but does not give me everything I want: select number from table group by number having count(*) > 1; Besides the numbers that are duplicated...

Part and Inventory Search

Back
Top