Odd SELECT queston???

Bill Karwin wrote:
 > Reestit Mutton wrote:
 >
  >> Each item in the resulting list should directly correspond to a field
  >> name (for a field of type ENUM with allowable values of 'TRUE' &
  >> 'FALSE') in my retailers list. i.e. each record in th eretailers table
  >> contains a single field of type ENUM for each leaf node in the
  >> menu_hierarchy table where the field names are used as values in the
  >> menu_hierarchy table.
 >
 >
 > Ah, now I understand what you're trying to do. No, you can't do that.
 >

<SNIP useful solution>

Thanks Bill, my problem is now solved thanks to you. I have also learned
that little bit more about the practicalities of relational database
design. (the theory was never a problem, I was just lacking the
practical experience)

cheers,
RM
--
Boots technology bargains with 10% off + triple advantage card points
e.g. iPod photo 40GB for £281, Nikon Coolpix 4100 for £117
where can I find more details (incl. other bargains & discount codes)?
<a rel="nofollow" style='text-decoration: none;' href="http://www.users.totalise.co.uk/~lauriem/latest_additions.html#0702200501" target="_blank">http://www.users.totalise.co.uk/~lauriem/latest_additions.html#0702200501</a>