Search String: Display: Description: Sort:

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*SQL\s+STATEMENT\s+TO\s+RELATE\s+TABLES\s*$/: 2 ]

Total 2 documents matching your query.

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