[mythtv-users] Help creating an SQL query from multiple tables

[Michael Rice]

The following is a query I use as part of a script I am writing to check for 
new movies:

select distinct title,description,airdate,stars*4 from program where airdate 
 >= 2005 and category_type = 'movie' order by title;

It works ok but I'd like to exclude any titles that I've recorded before.  
As I understand it that info is in two other tables (recorded, oldrecorded) 
and I don't exactly know how to join them.

If anyone could help I'd appreciate it... my wife would too since my 
attempts so far have managed to use 100% of the CPU and cause the frontend 
to slow or stop... :)

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/