Joining a table to itself

I'm hoping someone can help me with this. I have a table of categories that I'm trying to join to itself, but I keep getting the error unknown column: Cats1.parentid in on clause. Here is the SQL for the table: CREATE TABLE `vb_ldcats` ( `catid`int(10) AUTO_INCREMENT NOT NULL,

RE: Joining a table to itself

Thanks Shannon. :) -Original Message- From: Shannon Wade [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2008 4:04 PM To: Jim MacDiarmid Subject: Re: Joining a table to itself not sure i understand the order of your table joining i just reordered them and it works. SELECT

RE: Getting number days between 2 dates

I've been trying to figure this out using the CURDATE() function, but I keep getting a syntax error. Below is the code I'm using: SELECT `vb_links`.`DateAdded` FROM `vb_links` WHERE DATEDIFF( CURDATE() , `vb_links`.`DateAdded` ); Any thoughts? -Original Message- From: Mike Blezien