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-CodeSELECT 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-CODESELECT [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 query3. 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