MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » November 2006

Re: SQL from MS SQL Server



fixed

select * from a
....+....1...
MYKEY  MYDATA
  A    B 
  B    C 

select * from b
....+....1....+
MYKEY  ITSDATA 
  A    HI 

1. An unspecified join seems to be equal to an inner join - data must 
exist in both files.
SELECT A.MYKEY,A.MYDATA,B.ITSDATA FROM A
JOIN B USING (MYKEY) 
and
SELECT A.MYKEY,A.MYDATA,B.ITSDATA FROM A
inner JOIN B USING (MYKEY) 
both return only
....+....1....+....2..
MYKEY  MYDATA  ITSDATA
  A    B       HI 


2. LEFT JOIN seems to be equal to LEFT OUTER JOIN - pull from first/left 
most file all
records and any matching (if any) from the second file

SELECT A.MYKEY,A.MYDATA,B.ITSDATA FROM A LEFT JOIN B USING (MYKEY)
....+....1....+....2..
MYKEY  MYDATA  ITSDATA
  A    B       HI 
  B    C       - 

SELECT A.MYKEY,A.MYDATA,B.ITSDATA FROM A
LEFT OUTER JOIN B USING (MYKEY) 
....+....1....+....2..
MYKEY  MYDATA  ITSDATA
  A    B       HI 
  B    C       - 


3. Don't know if any of the tools in iNav will allow you to see where the 
person is being dropped.  But I have heard that the set of tools in iNav 
are so darn good for analysis that one shop switched from SQL Server on 
that basis alone.

Rob Berendt





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact