SQL in-Depth Articles from the Worx Company


Mon, 10/19/2009 - 2:50pm

We had a client requirement that a single view be the combination of:

  1. a random list of attorneys with offices in a given state
  2. a random list of attorneys that are licensed in a given state.

There should be no duplications and all of list 1 must precede list 2. We could not accomplish this with views alone. After talking to Earl, we were able to access the created SQL statement within views. Here we built each of the two queries. Then, we defined a 'pre' exit and replaced the query in our view with a new one.

Wed, 03/26/2008 - 5:51pm

As a premier Oklahoma Web Hosting firm, The Worx has dealt with a lot of different customers. And nearly every SQL variant is running somewhere in our Oklahoma DataCenter. But for this dicussion, I am going to limit my comments to MySQL and PostgreSQL.

Subscribe to

Our Web development team has developed thousands of websites for clients.
Both local and national.

We would love to help you in your business.


Phone Icon

Contact Us

email icon