darrylforma
Last Activity: Apr 28 '06, 01:30 PM
Joined: Apr 11 '06
Location:
-
The problem is that from TableC I only want values if (Table3.Column4 = SpecificValue2) otherwise I want it to return NULL values since I still need a row with the values from TableA and TableBLast edited by Niheel; Apr 11 '06, 05:02 PM. -
HELP with MS-SQL
What I need is an SQL query that joins three tables. TableA and TableB are joined on Column1 which is common to both. Rows are filtered by Column2 in TableA equalling a specific value SpecificValue1. TableB and TableC are joined by Column3 which exists in both tables. However, I need all rows from TableB regardless of whether or not there is a corresponding row in TableC.
Up to there has been no problem. However, the monkey wrench is...Last edited by Niheel; Apr 11 '06, 05:01 PM. -
HELP with sql query
What I need is an SQL query that joins three tables. TableA and TableB are joined on Column1 which is common to both. Rows are filtered by Column2 in TableA equalling a specific value SpecificValue1. TableB and TableC are joined by Column3 which exists in both tables. However, I need all rows from TableB regardless of whether or not there is a corresponding row in TableC.
Up to there has been no problem. However, the monkey wrench...
No activity results to display
Leave a comment: