Viewing 5 posts - 1 through 5 (of 5 total)
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....
April 14, 2008 at 2:21 pm
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...
April 14, 2008 at 10:50 am
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...
April 11, 2008 at 11:16 am
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...
April 10, 2008 at 3:29 pm
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,...
April 9, 2008 at 3:41 pm
Viewing 5 posts - 1 through 5 (of 5 total)