Right Join Query Issues
Posted by:
Bob Davies
Date: October 20, 2006 10:10AM
Hello.
I'm trying to generate a query for a security reporting tool we're developing. I'm pretty new to SQL so please bear with me.
I have three tables (actually, I have lots, but if I can get it to work with these three I think I'm good to go after that)
I have Table 1 (Scanlog)
IP
Date/Time
I have table 2: (nmapports)
IP
Date/Time
PortId
Protocol
Service
etc..
I have table 2 (amap)
IP
Date/time
PortId
AmapGuess
What I'd like is to be able to query an IP and get, to start, the following
IP (from scanlog)
PortID (from nmapports)
AMap Guess for that PortID (if there was one) (from amap)
Like I said, this is just a start. There'll be more to follow. I'm going to filter on the date/time so I get the results from a single scan, that's also for later.
What's important is that I get results for ALL IPs in the scanlog table, whether there were nmapports identified, or amap results. I thought that's what right joins do, but OOBase was giving me some jdbc heartaches.
if anyone can give me some guidance for generating the type of query I'm looking for, I'd really appreciate it.
Thanks in advance.
Bob
Subject
Written By
Posted
Right Join Query Issues
October 20, 2006 10:10AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.