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!

  • Congratulations Mike Lewis 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. tom22london

    Want to update a table via query on clicking command button

    Thanx for ur help guys i have solved my problem with the help of royvidor instructions. cheeers mate
  2. tom22london

    Want to update a table via query on clicking command button

    Hi members, I have a hospital database having a table name ADMISSION, I have a form(ADMISSIONCHARGESDETAIL)through which i charge(fee) patient once they are ready to get discharged from the hospital. this form has primary feild ADMISSION_ID, which is linked with the ADMISSION table's...
  3. tom22london

    can i bypass my proxy server

    Thanx for reply, but following is the detailed thing which we are talking about. Being resident in Arab, i can't access website through which i can download music, videos, pictures. Bewcuase its prohibited, proxy1.emirates.net.ae:8080 is the proxy server address which i have use to access to...
  4. tom22london

    can i bypass my proxy server

    hi, my computer run's internet behind a proxy server, is it possible that i can bypass my proxy server, so that i can use programs to donwload music, videos etc. regards tom
  5. tom22london

    Exchange server goes down in 10 minutes

    As soon as Exchange server starts it operation, after 10 minutes the IMS and Information Store services goes down completely. Please help me out
  6. tom22london

    Following are the tables (Feilds wi

    Following are the tables (Feilds with star are foreign keys, with + sysmbols are primary keys) Borrower(bor_id+, bor_name, bor_maxbooks) Book_title(bt_id+, bt_name,pub_id*, value) Book_copy(bc_id+, bt_id*, date acquired) Loan(bor_id+*, bc_id+*, date_out, date_due, date_back)...
  7. tom22london

    very confusing query !

    James' query is much more efficient but the thing is that error is coming in it. so if u can answer the query in an efficient manner than i will be thankful to u.
  8. tom22london

    is there any other shorter way to write these queries

    following are the three queries but its too long however answer is alright, but is there any way to make these query shorter Following are the tables (Feilds with star are primary keys) Borrower(bor_id*, bor_name, bor_maxbooks) Book_title(bt_id*, bt_name,pub_id, value) Book_copy(bc_id*...
  9. tom22london

    very confusing query !

    i have solved that query by myself so this was the answer, select bt_name from book_title bt1 where pub_id in(select pub_id from publisher where pub_id in(select pub_id from book_title bt2 where bt2.bt_name='tom')) and bt_name <> 'tom';
  10. tom22london

    how shall i find the total value of all books

    how shall i find the total value of all books the borrowers have currently on loan, where the total value is at least £20 for each borrower. Following are tables, Borrower (bor_id, bor_name, bor_maxbooks) Book_title (bt_id, bt_name,pub_id, value) Book_copy (bc_id, bt_id*, date acquired)...
  11. tom22london

    very confusing query !

    how can i find title of book whcih have the same publisher 'tom', but i am not supposed to include 'tom' in my output. following are the tables, Borrower (bor_id, bor_name, bor_maxbooks) Book_title (bt_id, bt_name,pub_id, value) Book_copy (bc_id, bt_id*, date acquired) Loan (bor_id, bc_id...

Part and Inventory Search

Back
Top