MySQL Forums
Forum List  »  Newbie

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

Options: ReplyQuote


Subject
Written By
Posted
Right Join Query Issues
October 20, 2006 10:10AM
October 20, 2006 10:15AM


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.