If your default is '0', I think, the new query should work. Thanks
Javier ----- Original Message ----- From: Donna Robinson <[EMAIL PROTECTED]> To: Javier <[EMAIL PROTECTED]> Sent: Monday, April 29, 2002 7:14 PM Subject: Re: Cross querying databases (again) > Hi, > > u r my hero. I never, never would have thought of that! And it's so bloody > obvious - i guess this is where experience comes in (sigh) > > well, i havent checked if this is the solution yet (have to rush off to go > dancing), but the declaration is: > ddref smallint(5) unsigned NOT NULL default '0', > > so if i said: > SELECT dancedata.dances.* FROM dancedata.dances > LEFT JOIN dancedetails.dances > ON dancedata.dances.dkey=dancedetails.dances.ddref > WHERE dancedetails.dances.ddref=0; > might that be the (a?) solution? > > Donna > > - Scanned for all known viruses by Messagelabs -- - Scanned for all known viruses by Messagelabs -- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php