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...
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...
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
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)...
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.
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*...
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';
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)...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.