Re: LEFT OUTER JOIN possible in DB2?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 07:57:55 +0200

> Unfortuantly, the AS400 doesn't use SQL Syntax.

Que? Your OP has SQL in it, and there certainly is a DB2 for AS 400, and that DB2 certainly uses SQL.

Or are you using some lower level of access to the database files? Your OP definitely suggested you are using
DB2 on the 400. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ian Boyd" <admin@SWIFTPA.NET> wrote in message news:u$haA0wiEHA.1652@TK2MSFTNGP09.phx.gbl...
> > The menu to the left, "Database and File systems", "DB2 Universal...",
> "Reference Information", "SQL Query
> > Syntax". Now search for, for instance "LEFT JOIN" on that page.
>
> Unfortuantly, the AS400 doesn't use SQL Syntax.
>
>

Relevant Pages

  • Re: any one complete MSD.NET and go on to do MCDBA?
    ... development to security), and started with ... configuring a network interface). ... stuff about database files, and also to know the syntax of the ... will show SQL syntax, and not EM screenshots. ...
    (microsoft.public.cert.exam.mcsd)
  • Re: Remote IP in Query
    ... "BeBoo" wrote in message ... > sql query. ... > error in your SQL syntax. ...
    (alt.php)
  • Remote IP in Query
    ... I need to grab the person's IP address and put it in the WHERE part of the ... sql query. ... error in your SQL syntax. ...
    (alt.php)