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 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
