Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-05 : 09:05:49
|
jo writes "I'm college student currently workin on a project which is a library system.. my prob is how to formulate a single SQL statement that would select mulitple records from different tables..
to further explain.. i have this "search facility", a single input box and a "go" button.. when the "go" buttton is clicked
i will select all records from the books, magazines, software and manual tables..
for the books, i will check if there is a match for the subject, author and title fields while manual table i will check for a match in the subject, project, and publisher fields..and other fields for the remaining tables (i hope my explanation is clear)..
please help.. i need this to pass and graduate..
" |
|
|
|
|
|
A single SQL stmnt to select records in multiple tables