[program-l] MS access 2003 sql vs Oracle 8I sql

  • From: Pranav Lal <pranav.lal@xxxxxxxxxxxxxxxxx>
  • To: "program-l-freelists.org" <program-l@xxxxxxxxxxxxx>
  • Date: Wed, 14 Sep 2005 21:09:34 +0530

Hi all,

In Oracle's implementation of sql, I am used to writing queries like
select x,y
from t a,q b
where t.item_id=b.item_id

I see this happening in Microsoft Access but I have also seen queries that use the words left, inner etc. Can some one point me to any tutorial explaining? Yes, it was a very long time ago when I read about left joines, inner joines etc. Some rtfm is in order but which manual do I choose? I will start with the Microsoft Access 2003 help.

Pranav
---------------------------------------------------------------------------------------------------------------------------------------
Pranav

** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq

Other related posts: