Simple question about AS/400 query
Maybe for you that will be a stupid question, but I’m taking the first steps and I don’t know what exactly I have to do in the “Specify how to join files” screen. If I put more joints in more rows it is how there was an “and” before every new row? I mean, all [...]

Answer Question   |  May 7, 2010  9:18 AM
AS/400 Query, JOIN statement

join tables with nested select count and group by
hi i am having three tables : state, agencydetail, parentdetaills i am running following queries but i am getting wrong result plz help me out where is the problem select state.state,count(ag.agencycode) as registag,count(ff.agencycode) as reportag,count(inp.regno) as incpwait,count(interp.regno) as intercpwait from state left outer join (select distinct agencycode,state from agencydetail) ag on state.state=ag.state left outer join [...]

Answer Question   |  July 29, 2008  6:28 AM
Database programming, JOIN statement, SELECT statement

Using Case Statement Inside SQL Join
Hi, I am trying to convert dynamic sql into static sql due to permission issue, I faced a challange when i am trying to convert this part of code given below -- join to ADDR_DETAIL SET @join_sql = 'inner join ADDR_DETAIL on ADDR_DETAIL.GRP_CONTACT_ID = pm.GRP_CONTACT_ID AND ' IF (@ChannelEntity = '') OR (@ChannelEntity IS NULL) [...]

Answer Question   |  March 17, 2008  11:08 AM
CASE statement, JOIN statement, SQL, T-SQL

LEFT JOIN vs. LEFT OUTER JOIN
I’ve been googling for 2 hours trying to find if there is a difference between LEFT JOIN and LEFT OUTER JOIN, and of course I didn’t find anything. Is there a difference? Is the word ‘outer’ optional, since a LEFT JOIN is an OUTER JOIN by default? If this is the case, I don’t understand [...]

Answer Question   |  September 13, 2012  9:51 PM
JOIN statement, Oracle, Oracle development

SQL statement using RRN(file) on join pulling only Max(date) records from second file in iSeries
I am using WebSmart with the I-series data base files. I am joining two data base files receiving the RRN so that I can use the fetch rrn and the fextnext to display one screen at a time in my WebSmart program. I have used this method many times except this time I have a [...]

Answer Question   |  February 21, 2008  7:00 PM
iSeries, JOIN statement, RRN, SQL

Showing all records
DATA SET: Table1 XID YID WRKDATE — — ——- 1 NOR 2007-01 2 SOU 2007-03 Table2 XID ZID QTY — — — 1 PEN 10 1 PAP 20 2 PAP 5 1 PEN 10 2 PAP 5 Result XID YID WRKDATE ZID QTY — — ——- — — 1 NOR 2007-01 PAP 20 1 NOR [...]

Answer Question   |  November 27, 2007  2:58 AM
JOIN statement, SELECT statement

Question on JOIN Clause
Folks, Is there any differences between selecting values from a table using JOIN clause, by using as JOIN or INNER JOIN. I mean, Will the result or performance changes when JOIN is used instead of INNER JOIN in MS SQL SERVER 2000/2005 Thanks in advance ! ash

Answer Question   |  November 2, 2007  9:00 AM
JOIN statement, SQL Server 2000, SQL Server 2005