• LEFT JOIN vs. LEFT OUTER JOIN

    I've been googling for 2 hours trying to find if there is a difference between LEFT JOIN and LEFT OUTER JOIN, and of course I didn't find anything. Is there a difference? Is the word 'outer' optional, since a LEFT JOIN is an OUTER JOIN by default? If this is the case, I don't understand the usage...

    OracleATE190 pointsBadges:
  • New Member contest: Win a free iPad

    Click here for all the details. Good luck to everyone.

    ITKE56,495 pointsBadges:
  • Free IT Book: Ubuntu Unleashed, 2011 Edition

    "Ubuntu Unleashed 2011 Edition presents advanced coverage of the popular Ubuntu distribution of Linux. Windows users, Mac users, and Linux enthusiasts have been increasingly turning to Ubuntu for a user-friendly and easy-to-use Linux distribution that remains useful to power users." To win this...

    MelanieYarbrough6,345 pointsBadges:
  • Use Oracle Forms to upload file to a specific folder

    Is there a way to use an Oracle Form to upload a file to a specific folder and store the filename in the database? I know how to do this through HTML/ASP/VBS, but my company wants it through Oracle Forms. Also, how would I make a hidden field appear when a LOV Item is selected and when it appears,...

    WmFenn0 pointsBadges:
  • Free IT Book: Enterprise Web 2.0 Fundamentals

    For an introduction to next-generation web technologies, Enterprise Web 2.0 Fundamentals is a great place to start. Learn how to leverage cloud computing and user-generated content along with business and technical best practices. To win this, simply answer one of the questions listed below and...

    MelanieYarbrough6,345 pointsBadges:
  • Set up DB2 Web Query dashboard

    I would like to be able to set up a dashboard on a particular managers desktop, and demonstrate the features of DB2 Web Query. Does anyone know of a good web site that I could go to, that would show me how to do this? Alternatively, are there any books on the market that someone would recommend?

    Piano510 pointsBadges:
  • Select fields in DB2 query without having them appear in ‘sort by’ window pane

    Hello Does anyone know how to select fields in the DB2 Query for report purposes, and yet not have them appear in the sort by window pane. Seem simple enough, but, when I have the field select tab highlighted, and double click on any field, the field automatically appears in the sort by window...

    Piano510 pointsBadges:
  • DB2 file names cause SQL error

    Hello I created metadata over a "set" of files. My next step is to define a primary over one of the files, and then foreign keys over the other files defined in my metadata relational database. Unfortunately, when I attempt to define my primary key over the main file, I receive an SQL error...

    Piano510 pointsBadges:
  • Biometrics and Privacy

    Which method(s) of biometrics that would not meet with undue resistance from potential users would you recommend to a manager to replace password-based access controls?

    nvme1110 pointsBadges:
  • Import AD data from CSV file to 2003 ad

    We have 3500 new ad users. How can we import their usernames, full names, phone numbers, email addresses from a CSV file.

    Karl Gechlik9,860 pointsBadges:
  • start career

    sir, I have completed my MCA in 2004,but not working after studies because I was in abroad with my family.Recently return back to chennai looking for good opportunity.I would like to start my career in ORACLE DBA.Which course in that will help me to start my career.Also can u suggest me any way to...

    Zap5 pointsBadges:
  • Free IT Book: Computer Incident Response and Product Security

    This week's free IT book is a practical guide to building and running incident response and product security teams. To win Cisco's Computer Incident Response and Product Security answer one of these five questions and post the link to your answer in the discussion area below. Good luck! Mitigating...

    MelanieYarbrough6,345 pointsBadges:
  • Run VBA code as admin

    I am currently working on an ms access application for a large insurance company which generates reports for the user after the user inputs/select some data.... Unfortunately the application has already been built - and till now we used to run the application/reports by logging in as admin.....

    Gangac5 pointsBadges:
  • Find Due Date From X months in Access 2007

    I have a database that has several different training topics each that a due at different intervals. I have a date completed field [Date completed] and reoccurs every x months [recurrence] and then the next due date [due date]. How do I get my database to calculate and store the next due date?...

    Desnyder200155 pointsBadges:
  • How to use lookup query to return only entries matching the related field of active record

    I'm creating a lookup field and would like to list only those items relevant to the record actively using the lookup. So my DB has two tables one using the lookup which as a child ID field that I'd like to match with the parent ID field of another table.

    YesMayhem5 pointsBadges:
  • MS Access 2007 mass email list?

    I was wondering is there a way to create a mass email from a query or table that would send out in MS Outlook? I know of a way of extracting a table and importing it into Outlook but my boss wants a more efficient way.

    Itguy1509220 pointsBadges:
  • Help Creating a Training Record Database

    We have an employee database that the managers want to use to track mandatory and option training. We already have an employee table, and I added two more. tblEmployee   (EmpID,EmpName,EmpProgram,EmpStatus,HireDate)  Has the basic employee information tblCourse      ...

    RaeLyn10 pointsBadges:
  • Need to modify an existing form in Access 2007

    I have just migrated to Access 2007 from previous versions. How do you bring up a window that displays all the objects in the database and then select one for modification. I have been able to modify tables and queries but cannot work out how to modify existing forms or reports.

    Mantis5 pointsBadges:
  • CPYTOIMPF error code 3025

    I am new to AS/400 and I wanted to transfer a file from AS/400 to PC using CPYTOIPMF as per advised here. But I am receiving an error, "File system error occurred" (Error number 3025) What's wrong?

    Radycal45 pointsBadges:
  • What is the difference between a logical file and view in DB2/400?

    What is the difference between logical file and View in DB2/400?

    rajeshece1,215 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following