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 derfloh 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. ashcarrot

    Adding a field in oracle with a unique identifier

    Maybe i should be saying adding a *record* RATHER than a field
  2. ashcarrot

    Adding a field in oracle with a unique identifier

    I know there must be something inbuilt with oracle or other dbs but i can't seem to find it i have a db each with a primary key 1 -> n i would like to create a new entry with the next available number as key. I could just SELECT max(id) and then plug it in though im worried about if someones...
  3. ashcarrot

    Multiple Lookups to a HR_TABLE

    Yeah the locked_by and updated_by may not have any links so in that case i need it to return blank So would SELECT check_id, created_by, locked_by, updated_by, a.name, b.name, c.name FROM reports,HR_DATA a,HR_DATA b,HR_DATA c OUTER JOIN a.usr_id = created_by and b.usr_id = locked_by and...
  4. ashcarrot

    Multiple Lookups to a HR_TABLE

    SELECT check_id, created_by, locked_by, updated_by FROM reports,HR_DATA WHERE ........ Where created_by , locked by and updated_by each defines a person by a unique id say 101 though i need to lookup the name of the person which are stored in HR_data as first_name and last_name and its unique...
  5. ashcarrot

    SQL - selecting items NOT IN tables

    I have a table of reports and assigned to each of them is a number of keywords REPORT(id, description, etc) KEYWORD(id, report_id, name) i want to get reports where there aren't certain keywords so something like SELECT DISTINCT(report.id) from keyword WHERE keyword NOT IN (1707,13,15) To...
  6. ashcarrot

    Linking tables

    Thanks thats done it :O)
  7. ashcarrot

    Linking tables

    Hi, I have two tables REPORT - hold details about a report and who has that locked (blank if its not locked) HR - Hold name, and id REPORT(details,locked_by) HR(usrid,firstname,lastname) now if i just use SELECT details,first_name,last_name FROM report,hr where report.locked_by =...
  8. ashcarrot

    Difficult SQL Qn

    Hi i have a table like Test_id, failed, passed, na where the data would be something like 101, 3, 2, 4 101, 2,7,8 101, 45,6,7 102, 234,5,3 102, 3,23,2 etc.... i want to idealy return the test_id and the total in each column for the for the biggest 5 (or however many) tests that failed...

Part and Inventory Search

Back
Top