FW: 2 SELECTS in 1

2004-07-05 Thread Quentin Bennett
PROTECTED] Sent: Tue 6/07/2004 8:22 a.m. To: [EMAIL PROTECTED] Subject: 2 SELECTS in 1 Hi, I have the following tables in my database for proxy logs. I have broken down the URL for each line into the following 4 tables: url_schemes e.g. http url_serverse.g. www.google.com url_paths

2 SELECTS in 1

2004-07-05 Thread J S
Hi, I have the following tables in my database for proxy logs. I have broken down the URL for each line into the following 4 tables: url_schemes e.g. http url_serverse.g. www.google.com url_paths e.g. /search url_queriese.g q="searchstring" To get a list of the websites a user has