Good Morning,
I have an issue where I need some guru help on (if possible ) I'm trying to Query across two tables in which have data that I need from both...
The tables are:
results
user_agents
I'm querying specific fields from the table results, but I want to also identify the user agent that is in the results field with all its data from the user_agents table..
So here's what I have so far:
Select result_date, ip_address, user_agent_id, latency from results where ip_address = inet_aton('10.10.120.120');
It brings back all the results from the IP i'm looking for, but there are 8 user_agent_id's associated with it.. I want to ID each user agent on each row with who they are from the user_agent table. I can't seem to get the syntax right and am wondering if someone could help me with that?
A sample of the output is as follows:
result_date * ip_address * user_agent_id * latency
4/13/2010 12:29:40 PM 111111111 1035332 40
If I query just the user_agent_id shown, I get:
user_agent_id user_agent os device platform browser_id browser_name browser_version
1041842 Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3 Windows 7 pc windows Firefox 3.6.3 Firefox 3.6.3
Thank you!