Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.oracle    |    Overblown overpriced overengineered SHIT    |    2,288 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 1,996 of 2,288    |
|    Nerfherder to All    |
|    Inner join with where    |
|    07 Feb 05 01:20:39    |
      From: nobody@home.com              I have the following SQL statement I need to       add a secondary where clause to              SELECT name, amount       FROM node, log       WHERE log.name (+) = node.name              Now I need to add run_date = '31-JAN-05',       I can not just add this statement since when I do       loose columns in the node table since there is       not a 1:1 match between the two tables.              --               --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca