Need help with Join please

[ned911]

I have 2 tables.

Table 1 contains the Agents that are used by search engine robots (googlebot, etc).

Table 2 contains web site visitor information including Agent, IP, Page visited, etc.

When I do a count to determine page views I get page views that were generated by Robots. I would like to exclude Robot visits.

I have tried left joins, creating array of robot agents (won't work because of certain characters in the robot agent).

Nothing is working. Any help would be appreciated.

Ned

[nnichols]

Give this a try -

SELECT a.*
FROM Table_2 a
LEFT JOIN Table_1 b
ON a.Agent = b.Agent
WHERE b.Agent IS NULL

Hope this helps 😉

[ned911]

That got it. Thank you.