Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010
    Posts
    12

    Unanswered: 4 Tables Join with comman column

    I have 4 tables one comman column (Date and Qty) and another field

    I want to join 4 tables with date as comman column.Some times qty will be null for particular date. I want to display all the dates even when one of table qty is Null.

    Further details provided.

    Thanks

  2. #2
    Join Date
    Jan 2013
    Posts
    354
    Provided Answers: 1

    Follow the rules, please.

    I have 4 tables one common column (Date and Qty) and another field [sic]
    I want to join 4 tables with date as common column.Some times qty will be NULL for particular date. I want to display all the dates even when one of table qty is NULL

    Further details provided. [sic: where? ]
    Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. Learn how to follow ISO-11179 data element naming conventions and formatting rules. Code should be in Standard SQL as much as possible and not local dialect.

    This is minimal polite behavior on SQL forums. But I will guess you need a calendar table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •