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 Chris Miller 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: *

  • Users: JenL
  • Order by date
  1. JenL

    How to Join in CR to simulate Not In from SQL

    synapsevampire: It's not a matter of being a coward but more matter of time constraints so in my situation right now, a db view is most definitely not an option in our environment (wishful thinking but impossible). Since these types of query are so easily done in SQL, I thought there might be...
  2. JenL

    How to Join in CR to simulate Not In from SQL

    Thank you everyone. I noticed that I forgot to mention that I am using CR 8.5 I will try to manually edit the SQL... however since we plan on going to a newer version of CR fairly soon I may just wait until then since it seems to be easier with other versions. Thanks once again! JenL
  3. JenL

    How to Join in CR to simulate Not In from SQL

    Have the following SQL query: SELECT REFERENCE# FROM TABLE_1 WHERE REFERENCE# NOT IN (SELECT REFERENCE# FROM TABLE_2) So basically, only want the reference# from the first table where there is no occurence of that reference# in the second table. Does anyone know how to simulate this in...
  4. JenL

    CLOBs and UNION in db views

    Have figured out that I can use UNION ALL... thanks anyway
  5. JenL

    CLOBs and UNION in db views

    Is it possible to use a UNION in an Oracle views when the queries being joined contain CLOB fields? Thanks!!!!!

Part and Inventory Search

Back
Top