Quote:
Originally Posted by mikesouth
give me the schema of the tables involved and the sql you're using for starters that may give me an idea of what you are trying to accomplish here
barring that give me the schemas and tell me what you are trying to do.
|
the schema is very simple, you can see it from the snapshot:
url text
url_domain text
referer text
referer_domain text
last_spidered date
i provided 2 dummy data rows from the table.
the task is to have an sql query that returns the columns/data listed in the output. the sql query would require an inner join
Fight the query!