Search results for query: *

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

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

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

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

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

Thanks thats done it :O)

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 =...

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