Pulling your hair out because of errors like so: "ERROR 1248 (42000): Every derived table must have its own alias" ?

If you have several complicated unioned queries that you want to use in a sub query try encapsulating them like so:

SELECT col1,col2,col3 FROM
(

SELECT * FROM
(
SELECT col1,col2,col3 FROM myTable WHERE ... etc.
) AS DerivedTable1

UNION

SELECT * FROM
(
SELECT col1,col2,col3 FROM myTable WHERE ... etc.
) AS DerivedTable2

) AS MainTable GROUP BY... HAVING... ORDER BY... LIMIT... etc.

This method of aliasing will add years to your life by providing the unique distinction required of derived tables in sub queries without having to spend a bunch of time trying to alias every table and field while continuing to get "derived table" errors. Thanks goes to David Fells for helping me keep some of my hair over this one!

Have fun.

          

          Tagged by mshook under 
         
6,

december,

2009,

a,

judell,

good,

listened,

church,

xml,

database,

social,

book,

fcc,

spectrum,

scarcity,

radio,

wireless,

cognitive,

game,

flickr,

xslt,

server,

pantry,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        Sun, 06 Dec 2009 07:41:00 -0500
      
    
      
      
      


  
    
  
  
  


      
        
        
        

          Tagged by mshook under 
         
22,

november,

2009,

b,

user,

experience,

radio,

tv,

wifi,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        Sun, 22 Nov 2009 06:44:00 -0500
      
    
      
      
      


  
    
  
  
  


      
        
        
        
I finished How I Became a Famous Novelist this morning.




by Steve Hely




He writes for 30 Rock.


He used to write for David Letterman.



via Terry Gross


Terry focused on Hely's parodies of various best selling genres. There is, in fact, a conflict within the first person protagonist between his cynicism and his non-cynical self. In the end Hely comes down on the site of (spoiler alert) earnestness. It speak to my own struggle against lazy cynicism. In the process there some legitimate discussion contrasting commercial and literary writing. There are views into how modern publishing works: selling a book, book tours, TV interviews, etc.





http://www.npr.org/templates/story/story.php?storyId=112883759


http://books.google.com/books?id=Lv3vlzBoPi4C
http://docs.google.com/View?id=accnfh3pfb3_897cztw9kf8


          

          Tagged by mshook under 
         
writing,

good,

parody,

freshair,

critique,

meaning,

cynicism,

formula,

genre,

22,

november,

2009,

a,

novel,

mynotes,

notes,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        Sun, 22 Nov 2009 03:22:00 -0500
      
    
      
      
      


  
    
  
  
  


      
        
        
        
...possible to glean certain patterns, and one that recurred as regularly as an urban legend was the one about how someone would move into a commune populated by sandal-wearing, peace-sign flashing flower children, and eventually discover that, underneath this facade, the guys who ran it were actually control freaks; and that, as living in a commune, where much lip service was paid to ideals of peace, love and harmony, had deprived them of normal, socially approved outlets for their control-freakdom, it tended to come out in other, invariably more sinister, ways.

Applying this to the case of Apple Computer will be left as an exercise for the reader, and not a very difficult exercise.

from In the Beginning was the Command Line available at:
http://artlung.com/smorgasborg/C_R_Y_P_T_O_N_O_M_I_C_O_N.shtml
and
http://www.cryptonomicon.com/beginning.html

          

          Tagged by mshook under 
         
20,

november,

2009,

a,

neal,

quote,

good,

apple,

jobs,

stevejobs,

control,

freak,

controlfreak,

culture,

cult,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        Thu, 19 Nov 2009 09:53:00 -0500
      
    
      
      
      


  
    
  
  
  


      
        
        
        

          Tagged by mshook under 
         
2,

november,

2009,

a,

onlywire,

twitter,

bug,

del.icio.us,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        Mon, 02 Nov 2009 09:03:00 -0500
      
    
      
      
      


  
    
  
  
  


      
        
        
        
OpenBTS is a software-based GSM access point, allowing standard GSM-compatible mobile phones to make telephone calls without using existing telecommunication providers' networks. OpenBTS is notable for being the first free software implementation of the industry-standard GSM protocol stack.
The GSM Software Project: We want to bring together all the folks that are interested in building a gsm receiver.

          

          Tagged by mshook under 
         
1,

november,

2009,

a,

cell,

telephone,

how,

howto,

gsm,

sdr,

cool,

interesting,

radio,

dsp,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        Sun, 01 Nov 2009 07:26:00 -0500
      
    
      
      
      


  
    
  
  
  


      
        
        
        
var TTP = {
    go : function(destination) {
        window.location.href = "http://" + destination;
    },
    term : function() {
        return document.appform.term.value;
    }
}


Term:


http://blog.jonudell.net/
Google pdafriendly
Google Mobile
del.icio.us/popular/
del.icio.us/url
Wikipedia Search


          

          Tagged by mshook under 
         
30,

october,

2009,

a,

html,

javascript,

del.icio.us,

pdafriendly,

forward,

search,

url,

mobile,

utiltiy,

*pda,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        Fri, 30 Oct 2009 01:01:00 -0400
      
    
      
      
      


  
    
  
  
  


      
        
        
        
Why REST Failed - "ERH complaining (rightfully) that browsers (and web presentation specs) should support PUT and DELETE out-of-the-box. I couldn't agree more. And yes, the title is unnecessarily inflammatory." | http://cafe.elharo.com/web/why-rest-failed/
Carrot Vs Orange discusses the benefits, drawbacks, and arguments for or against Pie Api approaches "HTTP using GET/POST to a single URI" (Carrot) vs. "HTTP using the REST Architectural Style" (Orange or simply REST). http://intertwingly.net/wiki/pie/CarrotVsOrangeDiscuss

          

          Tagged by mshook under 
         
28,

october,

2009,

a,

rest,

why,

links,

list,

samruby,

http,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        Wed, 28 Oct 2009 09:07:00 -0400
      
    
      
      
      


  
    
  
  
  


      
        
        
        
http://www.public.coe.edu/~theller/soj/now/betsey.htm
I like it because:

It includes a trip to a worlds fair by train, including hitching a ride
I know it's 1876
The principals are like some wonderful women I know
Reference to Maine's marine/trade heritage

Spoiler alert:

Betsy gets a bit of cash from a vistor. She sallies forth, walking to the station but before she get there she hitches a ride on a frieght. At the Philadelphia Centennial she befriends everyone, buys gifts for here friends and comes home.

This looks like a great site for all things Sarah Orne Jewett

          

          Tagged by mshook under 
         
23,

july,

2009,

a,

shortstory,

maine,

pdafriendly,

good,

railroad,

train,

rail,

poverty,

1876,

philadelphia,

saved,

sarahornejewett,

novel,

iowa,

academic,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        Sat, 24 Oct 2009 02:00:00 -0400
      
    
      
      
      


  
    
  
  
  


      
        
        
        

          Tagged by mshook under 
         
nyer,

writing,

job,

story,

narrative,

no,

neworleans,

iraq,

war,

rps,

interesting,

via,

2009,

twitter,

sentence,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        Wed, 14 Oct 2009 11:13:00 -0400
      
    
      
      
      


  
    
  
  
  


      
        
        
        

          Tagged by mshook under 
         
via,

wave,

popular,

usecase,

docs,

example,

october,

2009,

howto,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        Wed, 14 Oct 2009 09:33:00 -0400
      
    
      
      
      


  
    
  
  
  


      
        
        
        
http://www.newyorker.com/online/podcasts/outloud
http://www.newyorker.com/online/podcasts/comment

          

          Tagged by mshook under 
         
4,

october,

2009,

b,

nyer,

podcast,

writing,

comparison,

conversation,

preference,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        Sun, 04 Oct 2009 04:30:00 -0400
      
    
      
      
      


  
    
  
  
  


      
        
        
        
Rational Irrationality - The real reason that capitalism is so crash prone by John Cassidy - The New Yorker - October 6, 2009
Steven Strogatz on sync - TED Talk - See also Collective dynamics of 'small-world' networks.


          

          Tagged by mshook under 
         
4,

october,

2009,

a,

economics,

via,

max,

nyer,

emergence,

feedback,

london,

bridge,

pdafriendly,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        Sun, 04 Oct 2009 04:19:00 -0400
      
    
      
      
      


  
    
  
  
  


      
        
        
        How do I add an available load to the load board? 
 
Proceed to the "Add a Load" page from the "My Account" dropdown menu, fill out all relevant fields, and click "Add Load" at the bottom of the page.


  	  	  	 
How do I add an available Truck to the load board?
Proceed to the "Add a Truck" page from the "My Account" dropdown menu, fill out all relevant fields, and click "Add Truck" at the bottom of the page
          

          Tagged by mshook under 
         
truck,

paper,

business,

october,

2009,


]]>

        
        
        
        
        
        
        
        
        
        
        
        
        Sun, 04 Oct 2009 12:09:00 -0400
      
    
      
      
      


  
    
  
  
  


      
        
        
        
drainage
fence
aesthetics
cost
maintenance
snow
table

Quiz time: Which of the following provisions has been tucked into the most closely watched health-care bill on Capitol Hill thanks to Senator Olympia Snowe of Maine? Is it a) an annual checkup for every Medicare beneficiary, b) a special health-insurance marketplace in every state that would cater to the needs of small businesses or c) new tax credits to help modest-size firms buy coverage for their workers?