- 1. SQL STATEMENT TO RELATE TABLES (score: 1)
- Author: Gerardo Zapata <gerardo.zapata AT USA DOT NET>
- Date: Wed, 25 Jul 2001 13:40:53 CDT
- HI, I'M TRYING TO ELABORATE AN SQL STATEMENT TO GET INFORMATION FROM TWO DIFFERENT TABLES USING A SINGLE COMMAND. THE OBJECTIVE IS TO DETERMINE THE NAME OF A VOLUME CONTAINING A SPECIFIC ARCHIVE FROM
- /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2001-07/msg00775.html (10,833 bytes)
- 2. Re: SQL STATEMENT TO RELATE TABLES (score: 1)
- Author: Scotty Logan <swl AT STANFORD DOT EDU>
- Date: Wed, 25 Jul 2001 21:11:52 -0700
- This worked for me: SELECT DISTINCT contents.node_name,contents.volume_name, - archives.archive_date, archives.description - FROM contents,archives - WHERE contents.node_name = 'THUNDERBIRD - AND con
- /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2001-07/msg00785.html (11,271 bytes)
This search system is powered by
Namazu