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!
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.