How to select just the row in the second table?

by

I think you need to use a case statement for the value. Below is just off the top of my head, so you may need to use full join if that doesn’t work.

select t1.date, case when t3.IDCLIENT is not NULL then t3.value else t2.value end as Value
from Table1 t1 inner join Table2 t2 on t1.IDCLIENT = t2.IDCLIENT inner join
Table3 t3 on t1.IDCLIENT = t3.IDCLIENT

More Related Contents:

  1. SQL update query using joins
  2. Difference between numeric, float and decimal in SQL Server
  3. Select n random rows from SQL Server table
  4. T-SQL: Deleting all duplicate rows but keeping one [duplicate]
  5. Querying data by joining two tables in two database on different servers
  6. SQL: IF clause within WHERE clause
  7. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  8. “CASE” statement within “WHERE” clause in SQL Server 2008
  9. SQL Server – How to lock a table until a stored procedure finishes
  10. Where value in column containing comma delimited values
  11. How to use table variable in a dynamic sql statement?
  12. How to create a unique index on a NULL column?
  13. Search text in stored procedure in SQL Server
  14. What happens to an uncommitted transaction when the connection is closed?
  15. Create Trigger to log SQL that affected table?
  16. Difference between datetime and timestamp in sqlserver? [duplicate]
  17. Solution for: Store update, insert, or delete statement affected an unexpected number of rows (0) [closed]
  18. Cannot use UPDATE with OUTPUT clause when a trigger is on the table
  19. SQL grouping by month and year
  20. “IN” clause limitation in Sql Server
  21. Meaning of square brackets [] in MS-SQL table designer? [duplicate]
  22. Selecting first row per group
  23. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  24. SQL Server Convert integer to binary string
  25. How to find column names for all tables in all databases in SQL Server
  26. SQL update trigger only when column is modified
  27. Passing dynamic order by in stored procedure
  28. SQL query to group by day
  29. Should I use the CASCADE DELETE rule? [duplicate]
  30. SQL, How to Concatenate results?

Leave a Comment