sql statement... need joins! - 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

SQL Server 2000 Forums

Transact-SQL (2000)

sql statement... need joins!

Author

Topic

ezrasuncle
Starting Member

2 Posts

Posted - 2004-08-10 : 04:36:56

Greetings,

Can anyone help me alter this SQL statement to have join conditions? My brain's not working too well at the moment. I need it for Oracle Forms...

SELECT BEZEICHNUNG, I_UEBER_NR
FROM I_UEBER
WHERE I_UEBER_NR IN
(SELECT I_UEBER_UMS
FROM I_UEBER_BEZ
WHERE I_UEBER_FIX IN
(SELECT I_UEBER_NR
FROM I_UEBER
WHERE BEZEICHNUNG = v_value))
GROUP BY BEZEICHNUNG, I_UEBER_NR

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2004-08-10 : 08:47:09

maybe??


SELECT 
	BEZEICHNUNG, 
	I_UEBER_NR
FROM I_UEBER as Z
Inner Join
	(
		SELECT 
			I_UEBER_UMS
		FROM I_UEBER_BEZ as A
		Inner Join I_UEBER as B
		On A.I_UEBER_FIX = B.I_UEBER_NR
		Where B.BEZEICHNUNG = v_value
	) as Y
On Z.I_UEBER_NR = Y.I_UEBER_UMS
GROUP BY BEZEICHNUNG, I_UEBER_NR

Corey

ezrasuncle
Starting Member

2 Posts

Posted - 2004-08-10 : 08:57:43

Wow! In Oracle SQL i just had to get rid of the "as" in the from clause, but other than that, You got it! It works perfectly! Thanks very much!!

quote:

Originally posted by Seventhnight

maybe??


SELECT 
	BEZEICHNUNG, 
	I_UEBER_NR
FROM I_UEBER as Z
Inner Join
	(
		SELECT 
			I_UEBER_UMS
		FROM I_UEBER_BEZ as A
		Inner Join I_UEBER as B
		On A.I_UEBER_FIX = B.I_UEBER_NR
		Where B.BEZEICHNUNG = v_value
	) as Y
On Z.I_UEBER_NR = Y.I_UEBER_UMS
GROUP BY BEZEICHNUNG, I_UEBER_NR

Corey

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2004-08-10 : 09:04:01

I'm surprised... but glad i could help!

Corey

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources