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)
 Multipe Tables JOIN

Author  Topic 

Thomkurz
Starting Member

1 Post

Posted - 2014-08-29 : 06:12:54
I want to Combine this two SQL-Code cand someone help me ?

//first SQL-Code
SELECT D.Datei_ID
FROM DOKUMENTENINHALT AS D INNER JOIN BEZIEHUNG AS B

ON (D.Datei_ID = B.DATEI_ID)

WHERE D.Dokumenten_ID = ? AND B.LOBJ_ID=3181


//secound SQL-CODE
SELECT [Datei_ID], [Name], [Titel] FROM [DATEI] WHERE (([Datei_ID] = ?) AND ([Titel] IS NULL))



if try it with INNER JOIN but it doesn't work:(

thx for help

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-08-29 : 07:57:20
We need more to work with.

1. Why do you want to combine these two queries?
2. Can you post and example of the desired output from such a combined query
3. When you say "it doesn't work" do you mean:
a. It doesn't compile (that is, SQL won't execute your query)
b. It produces incorrect results (in which case, post the incorrect results as well)
4. Post your attempt at a combined query
Go to Top of Page
   

- Advertisement -