[vox-tech] MySQL 3.x - deleting orphan rows & datetime()

[David Siedband]

Greetings,

I have two questions - using MySQL 3.x

[1] I'm trying to craft an SQL query to delete orphan rows in index 
tables

something like:

delete from DocWords left join Docs on Docs.ID = DocWords.DocID where 
Doc.ID is null

Any suggestions how to do this?

[2] Is it possible to emulate the functionality of difftime() in MySQL 
3.x without using a scripting language?

thanks!
--
David