Post reply

Simple Query Help -- but I am missing it

  • November 10, 2005 at 9:49 pm

    #95727

    Hello All,

    I need help to create  a simple query :

      Tables are as follows

           Table Name                  Keys 

           tblResv           kResNum    PK

           tblInvoiceHdr   kResum      FK

           tblInvoiceDtl   kResNum     FK

    I need to create a query which

        will return all records in tblResv and their associated  Invoice and Invoice Dtl

     Even if a record in tblResv has no records I want it returned.

    If there are invoice records then link all 3 tables

    Do I need an LEFT INNER Join on    tblREsv and tblInvoiceHdr and a

    Inner Join on tblInvoiceHdr and  tblInvoiceDtl

    Thanks for your help

    Yorgs

     

     

     

     

  • November 11, 2005 at 6:48 am

    #603404

    a left outer join would select all records from tblResv.... but there really is not enough info from the table description provided to give you the SQL.... I am lazy and build all my SQL from the query builder it's easy and you can keep changing the SQL quickly to make sure you have the sort of results needed.

  • November 11, 2005 at 6:49 am

    #603405

    also you should be pitching this question in the T-SQL forum area

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply