New need help.. - 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

New need help..

Author

Topic

ds72145
Starting Member

1 Post

Posted - 2012-10-18 : 03:07:19

Hi all

Just starting out with SQL etc having a few teething problems hoping someone can assist ...

I have a query that requires 3 tables I have had a go but cant seen to get it to work..

SELECT A.ID, A.NAME, A.D_NAME, A.D_CODE, A.STATUS, B.C_NAME
FROM CLIENT A, CLIENT_CLASS B, CLIENT_CLIENT_CLASS C
LEFT OUTER JOIN A.CLIENT ON (A.ID = C.ID)
JOIN C.CLIENT_CLIENT_CLASS ON (B.CLIENT_CLASS_ID=C.CLIENT_CLASS_ID)
WHERE B.CLASS_TYPE_CODE = 'BBGJ'

Any help would be much appreciated..

Thanks

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2012-10-18 : 03:13:17

Just guessing...

SELECT A.ID, A.NAME, A.D_NAME, A.D_CODE, A.STATUS, B.C_NAME
FROM CLIENT_CLASS B
LEFT OUTER JOIN CLIENT A ON A.ID = C.ID
JOIN CLIENT_CLIENT_CLASS C ON B.CLIENT_CLASS_ID=C.CLIENT_CLASS_ID
WHERE B.CLASS_TYPE_CODE = 'BBGJ'

Too old to Rock'n'Roll too young to die.

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2012-10-18 : 03:52:25

SELECT A.ID, A.NAME, A.D_NAME, A.D_CODE, A.STATUS, B.C_NAME
FROM CLIENT A
LEFT OUTER JOIN CLIENT_CLIENT_CLASS C ON (A.ID = C.ID)
JOIN CLIENT_CLASS B ON (B.CLIENT_CLASS_ID=C.CLIENT_CLASS_ID)
WHERE B.CLASS_TYPE_CODE = 'BBGJ'

--
Chandu

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources