>... Is there someplace where I can get examples of complicated SQL statements (ie. subquerys etc) with visual foxpro ?

There are books covering ANSI SQL, but not much in the way of VFP-specific SQL beyond the Help. This is where experience comes in. You can learn a lot from newsgroup posts though. You could get a Premier membership here and search the archives to see what turns up.