Querying a database is just half of the battle. The other half is making the data that is pulled out of the table look pretty. Reports are used for those non-techie, higher ups that like it when things look pretty.
Using a debugger to help find errors will save you a consider amount of time. Eclipse is a great IDE because not only is it platform independent, but you can use it to program in many different languages. The features and plugins seem endless which is an added bonus.
The main reason why I like it is that it works on Linux. 
Views have two purposes:
Views are Database objects and are treated like tables. Unlike tables, views do not store any data. Views simply store a query.
Linux is great in the respect that you have COMPLETE control over everything you do on the system. You can even control the mounting of drives. However, sometimes you may just want the system to mount it itself. I’ve read that many people were having problems with supermount and it is no longer mainstream.
This is where IVMan comes into play. Submount was removed from the Gentoo Portage as of 2nd of Janurary, 2007. As long as my system mounts a USB stick at when I plug it in, I’m a happy camper.
In order to use ivman, the system must have the following installed for it to work correctly:
udev
hal
dbus
This is a quick and dirty way of how I set up ivman to work on my system. I use Gnome, so if you use Gnome as well, you may want to make sure that coldplug and gnome-volume-manager is installed.
# emerge -av ivman
# emerge –oneshot glibc linux-headers
# emerge coldplug gnome-volume-manager
# rc-update add ivman default
# rc-update add hald default
# rc-update add dbus default
# /etc/init.d/ivman start
Make sure that the users that need the ability to mount devices automatically are added to the plugdev group.
Chances are that if you plug in a USB flash drive, it’s going to tell you that you do not have permission to view the contents of the drive. Since whenever I plugged in a UFD, it would always get assigned /dev/sdd1, I just added the following line to my /etc/fstab file:
/dev/sdd1 /media/sdd1 auto users,rw 0 0
At work we have a Core 2 demo running Windows Vista. This demo is not connected to the network because we don’t want people coming in and changing the background image to display something obscene or pornographic. There is a neat little trick that I found one day while trying to figure out how I could reset the time until the user had to activate Windows Vista.
HTML Source EditorWord wrap Sub queries come in handy when you want to find a record but need to know what exactly to look for. For example, if you want to find all the items that are more expensive than a specific item. Instead of issuing two SELECT statements, you can use sub queries to find the answer in just one query.
When designing Sub queries, the first query that is designed is the sub query. In order to execute sub queries correctly, you must determine what it is that you are looking for. After successfully testing the sub query, it is this that will be passed as input to the parent query or the outer query.