Mahender

• Mar 2nd, 2006

 

Joining the fileds using the the between operator

eg:agerange.....to maxage and minage

Mahiiii

Murali

• Apr 29th, 2006

 

Theta join?A theta join is created when the data in two fields from two tables is related via some comparison operator other than equals (=). For example, a not-equal join relates data using the not equal operator (<>). For example, suppose you want to compare the unit price data in Northwind's Order Details table with the unit price data in the Products table. Specifically, you want to see those orders where the unit price of the order differs from the unit price of the product. --- Copied from http://www.informit.com/articles/article.asp?p=330333&seqNum=4&rl=1