* [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.id,pix_use.typeseq,pi > x.width,pix.height,pix_big.bigpixid,bigpix.filename > from pix_use
Have you tried aliasing the fields...? select pix_section.code,pix.filename AS "pix_filename",pix.id,pix_use.id,pix_use.typeseq,pi x.width,pix.height,pix_big.bigpixid,bigpix.filename AS "bigpix_filename" from pix_use -- Roger sql --------------------------------------------------------------------- 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
