Date: Wed, 6 Mar 2002 08:52:22 +1000
Reply-To: Peter Baade <Peter_Baade@HEALTH.QLD.GOV.AU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Peter Baade <Peter_Baade@HEALTH.QLD.GOV.AU>
Subject: Re: SQL logic
Content-Type: multipart/mixed;
Thanks to all those who replied to my question about SQL logic. I found that the sequential LEFT JOIN method worked perfectly.
Some people suggested nested queries, and others talked about FULL JOINS or RIGHT JOINS, and I realised that my understanding of SQL was not as robust as I thought.
Is there recommended manual for SQL? We use SQL for both SAS and ORACLE (I understand there are some differences), so recommendations for both types would be much appreciated.
Thanks again for the replies.
Peter.
**********************************************************************
This e-mail, including any attachments sent with it, is confidential
and for the sole use of the intended recipient(s). This confidentiality
is not waived or lost if you receive it and you are not the intended
recipient(s), or if it is transmitted/ received in error.
Any unauthorised use, alteration, disclosure, distribution or review
of this e-mail is prohibited. It may be subject to a statutory duty of
confidentiality if it relates to health service matters.
If you are not the intended recipient(s), or if you have received this
e-mail in error, you are asked to immediately notify the sender by
telephone or by return e-mail. You should also delete this e-mail
message and destroy any hard copies produced.
**********************************************************************
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META content="MSHTML 5.00.2919.6307" name=GENERATOR></HEAD>
<BODY style="FONT: 8pt MS Sans Serif; MARGIN-LEFT: 2px; MARGIN-TOP: 2px">
<DIV><FONT size=1>Thanks to all those who replied to my question about SQL
logic. I found that the sequential LEFT JOIN method worked
perfectly.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=1>Some people suggested nested queries, and others talked about
FULL JOINS or RIGHT JOINS, and I realised that my understanding of SQL was not
as robust as I thought.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=1>Is there recommended manual for SQL? We use SQL for both SAS
and ORACLE (I understand there are some differences), so recommendations for
both types would be much appreciated.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=1>Thanks again for the replies.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=1>Peter.</FONT></DIV></BODY></HTML>
| 
