Re: Simplifying Queries

2014-07-20 Thread shawn l.green
Hello Surya, Part of the problem may be that you are so focused on the details that might have lost sight of the purpose. On 7/12/2014 8:24 AM, Surya Savarika wrote: Hi, I have two query series that I wonder whether they can be compacted into a single query: FIRST QUERY SERIES cursor

Simplifying Queries

2014-07-12 Thread Surya Savarika
Hi, I have two query series that I wonder whether they can be compacted into a single query: FIRST QUERY SERIES cursor.execute("""select d.ID, d.Name, b.SupersetID from books_data as d join books as b on d.ID=b.BooksDataID2 where b.BooksDataID!=b.BooksDataID2 and b.Religio