[program-l] Re: MS access 2003 sql vs Oracle 8I sql
- From: David Lant <david.lant@xxxxxxxxxxxx>
- To: "'program-l@xxxxxxxxxxxxx'" <program-l@xxxxxxxxxxxxx>
- Date: Wed, 14 Sep 2005 17:50:56 +0100
Hi Pranav,
I learned about inner and outer joins from the Access online documentation.
So I think you should find everything you're looking for there. You're
basically looking at INNER JOIN, LEFT JOIN and RIGHT JOIN.
David Lant
I.T. Consultant
Consultancy & Development
ICT Services
Tel: (01392) 382464
Devon County Council accepts no legal responsibility for the contents of
this message. The views expressed do not reflect those of Devon County
Council.
-----Original Message-----
From: Pranav Lal [mailto:pranav.lal@xxxxxxxxxxxxxxxxx]
Sent: 14 September 2005 16:40
To: program-l-freelists.org
Subject: [program-l] MS access 2003 sql vs Oracle 8I sql
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
** 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:
