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