select multiple joins to display using more than 3 tables [closed]

by 

Select c.Id, c.Name from Client c 
    Join ClientArticle ca on c.ID = ca.ClientID
    Join Article a on ca.ArticleID = a.ArticleId
    Where a.Value="Y"

You will need to play with the join types depend on the results you want. IE. Left Join, Inner Join etc

More Related Contents:

  1. How can prepared statements protect from SQL injection attacks?
  2. SQL update query using joins
  3. Removing duplicate rows from table in Oracle
  4. Optimise PostgreSQL for fast testing
  5. When to use “ON UPDATE CASCADE”
  6. SQL: IF clause within WHERE clause
  7. Where value in column containing comma delimited values
  8. Search text in stored procedure in SQL Server
  9. Generate sql insert script from excel worksheet
  10. Pivoting of data using two columns
  11. Selecting first row per group
  12. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  13. Foreign Key Creation issue in Oracle
  14. How to find column names for all tables in all databases in SQL Server
  15. COPY with dynamic file name
  16. How to make a parametrized SQL Query on Classic ASP?
  17. MySQL GROUP BY behavior
  18. SQL update trigger only when column is modified
  19. How to get rid of “Error 1329: No data – zero rows fetched, selected, or processed”
  20. Should I use the CASCADE DELETE rule? [duplicate]
  21. IF() statement alternative in SQLite
  22. Dynamic order direction
  23. Why is RAND() not producing random numbers?
  24. Select query with date condition
  25. Oracle Convert TIMESTAMP with Timezone to DATE
  26. Does MS access(2003) have anything comparable to Stored procedure. I want to run a complex query in MS acceess
  27. Microsoft Access – Case Query
  28. DATE_DIFF but only counting business days
  29. SQL, How to Concatenate results?
  30. MySQL: Typecasting NULL to 0

Leave a Comment