sql 2000/2005 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

sql 2000/2005

Author

Topic

kidaduo
Starting Member

45 Posts

Posted - 2008-06-20 : 10:11:04

queation:

why running the follwing qry in sql 2005 is not working?

SELECT i.namelong "AMC_FULL_NAME",
s.acqdate "FORECLOSURE_ACQ_DT",
m.ns_acqdate "DATE_OF_RELEASE",
m.ns_conphon "SERVICER_PHONE",
0 "TOTAL_AMT_DELQ"
from country i,
city m,
state s
where m.deptno *= i.code1
and i.cd_type = 'dept'
and m.uniq_id *= s.muniq_id

Josephine

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-20 : 10:22:47

You need to use ANSI join syntax. like this:-

SELECT i.namelong AS AMC_FULL_NAME, 
s.acqdate AS FORECLOSURE_ACQ_DT,
m.ns_acqdate AS DATE_OF_RELEASE,
m.ns_conphon AS SERVICER_PHONE,
0 AS TOTAL_AMT_DELQ
from country i 
LEFT JOIN city m
ON m.deptno = i.code1
LEFT JOIN state s
ON m.uniq_id = s.muniq_id
where  i.cd_type = 'dept'

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-06-21 : 06:38:56

*= is not supported

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources