|
|
|
|
Browse by Tags
All Tags » INNER JOINS (RSS)
-
Hello All,
I am looking for some general advice concerning views vs. tables. I have several processes for which I have created multiple views. In other words, View 2 depends on View1 and so on. Some of these are nested 6-8 deep.
I had some initial difficulty with unexpected join results (SQL choosing a different join than what ...
-
Try:
SELECT Q.Qname
FROM Question q
INNER JOIN Category_Details cd ON cd.idquestion = q.idquestion
INNER JOIN Category c ON c.idCategory = cd.idCategory
WHERE CategoryName = @CategoryName
... you can also eliminate the RETURN SCOPE_IDENTITY(). That only makes sense when you're inserting into a table with an IDENTITY column, and in ...
|
|
|
|
|