Re: Problem JOINing with Aliases

2002-10-31 Thread Bruce Hodo
No, I hadn't. So I did. IT WORKED! Thank you very much! Roger Baklund wrote: * [EMAIL PROTECTED] [...] In other words, any pix that has a bigpix defined is ok. But on any pix that does not have a bigpix defined, I "loose" the filename info from pix. And I don't understand why! Here is the

Re: Problem JOINing with Aliases

2002-10-31 Thread Roger Baklund
* [EMAIL PROTECTED] [...] > In other words, any pix that has a bigpix defined is ok. But on any > pix that does not have a bigpix defined, I "loose" the filename info > from pix. > > And I don't understand why! > > Here is the second query: > > select > pix_section.code,pix.filename,pix.id,pix_use.

Problem JOINing with Aliases

2002-10-30 Thread Bruce Hodo
I have a database defined with the following tables: CREATE TABLE pix ( id int(11) NOT NULL auto_increment, propertyid int(11) NOT NULL default '0', filename varchar(25) default NULL, caption varchar(50) default NULL, width smallint(4) unsigned NOT NULL default '0', height smallint(4)