Multiple Inner Join Help

Discussion in 'Databases' started by datropics, Sep 19, 2007.

0
  1. #1
    Hello peeps. I have a query running and it is running duplicate results. Is there a better way for me to write the from cause of this? Note below:
    
	FROM DLDIB
	-- LINK DEALS
	INNER JOIN DEALS ON DEALS.DEAACC = DLDIB.DLDACC AND (DEALS.DEASTS <> 'C')
	-- LINK ACCOUNT
	INNER JOIN ACCOUNT ON 
								ACCOUNT.[ALT.ACCT.ID] = DEALS.DEAACC AND 
								ACCOUNT.[ALT.ACCT.ID] = DLDIB.DLDACC AND
								CONVERT(NVARCHAR, ACCOUNT.[@ID]) NOT IN 
								(
									SELECT 
										SUBSTRING(
											CONVERT(NVARCHAR, STPID), 
											1, 
											CASE 
												WHEN CHARINDEX('.',CONVERT(NVARCHAR, STPID)) > 0 THEN 
													CHARINDEX('.', CONVERT(NVARCHAR, STPID))-1 
												ELSE 
												LEN(STPID) 
											END 
										) 
									FROM FileDone
	) 
									INNER JOIN POSWFDISTINCT as POSWF ON POSWF.POSACC = DLDIB.DLDACC
	WHERE DLDPVI = '1'
    Code (markup):

     
    datropics, Sep 19, 2007 IP