Ok, So here is what I am trying to do, I have 2 tables one with DSL IP addresses and one with Dialup addresses. I need to be able to query both tables and extract the information by IP address but I will not know which table the data is in before I do the search. Basically I want to have a query that states "look in both tables and if the ip is found in either then give me some fields from that table" What I have tried already is things like this: Select DISTINCT DIALUP.Full_Name, DIALUP.Framed_IP_Address, DSL.Full_Name, DSL.Framed_IP_Address >From DIALUP, DSL Where DSL.Framed_IP_Address = "65.xxx.196.175" or DIALUP.Framed_IP_Address = "65.xxx.196.175" LIMIT 500 However that doesn't work because it returns rows from the table that the IP address is NOT in as well, because of the self join that is being done. All help will be GREATLY appreciated. Chris Hood Investigator Verizon Global Security Operations Center Email: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] Desk: 972.399.5900
Verizon Proprietary NOTICE - This message and any attached files may contain information that is confidential and/or subject of legal privilege intended only for the use by the intended recipient. If you are not the intended recipient or the person responsible for delivering the message to the intended recipient, be advised that you have received this message in error and that any dissemination, copying or use of this message or attachment is strictly forbidden, as is the disclosure of the information therein. If you have received this message in error please notify the sender immediately and delete the message.
