Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

  • RE: Hiding duplicate rows

    Hi Terry,

    I've tried using table JCCI as the primary table, and linking the other 2 off just JCCo and just Contract and I still come up with the same result....

  • RE: Hiding duplicate rows

    I downloaded TOAD - this looks like it's going to a pretty handy tool, thanks for the tip.

    There are no key's on any of the three tables, and I don't...

  • RE: Hiding duplicate rows

    I think I am following what you are asking. I don't know how to determine if a column is a primary or foreign key. :unsure: My experience with...

  • RE: Hiding duplicate rows

    Thanks for everyone's replies. 🙂

    Here is what I know - all 3 tables have JCCo as an indexed column. Tables JCCI and JCCM both have Contract as an indexed...

  • RE: Hiding duplicate rows

    SELECT JCCI.Contract AS 'Contract #', JCCI.Description, JCCI.Item, JCCI.Department, JCCI.RetainPCT, JCCI.OrigContractAmt, JCCI.OrigContractUnits, JCCI.OrigUnitPrice, JCCI.ContractAmt, JCCI.ContractUnits, JCCI.UnitPrice, JCCI.BilledAmt, JCCI.BilledUnits, JCCI.ReceivedAmt, JCCI.CurrentRetainAmt, JCCI.BillOriginalUnits, JCCI.BillOriginalAmt, JCCI.StartMonth, JCCM.Description AS 'Job Name', JCCM.ContractStatus, JCCM.StartMonth, JCCM.StartDate, JCCM.MonthClosed,...

Viewing 5 posts - 1 through 5 (of 5 total)