[AccessD] SQL theta-joins

Charlotte Foust cfoust at infostatsystems.com
Thu Dec 23 10:38:45 CST 2004


That is a wonderful overview of all kinds of relational stuff, Gustav.
Thanks for the link.  I suspect whoever added that to the wish list
didn't really understand the way theta-joins are expressed in SQL.

Charlotte Foust


-----Original Message-----
From: Gustav Brock [mailto:Gustav at cactus.dk] 
Sent: Thursday, December 23, 2004 8:26 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] SQL theta-joins


Hi all

Found one myself:

  http://learning.unl.ac.uk/ib212/week6/handout.htm 

/gustav

>>> Gustav at cactus.dk 23-12-2004 16:52:24 >>>
Hi all

>From the wish-list for Access:

http://www.smartaccessnewsletter.com/ME2/Audiences/dirmod.asp?sid=&nm=&t
ype=Publishing&mod=Publications%3A%3AArticle&mid=8F3A7027421841978F18BE8
95F87F791&AudID=C01C1922F71E483AB162D148B15A6F6D&tier=4&id=6F405924A71D4
B00A251C0567C463859

---
"Support for theta-joins joins using (<>, >, >=, <, <=) arguments and
Union queries in the query design window." 
I suspect that most developers don't even know that Access actually
supports these extensions, so this suggestion would be a worthwhile way
to bring these concepts into the mainstream.
---

Anyone having examples on theta-joins?

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list