Re: query help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Anith Sen (anith_at_bizdatasolutions.com)
Date: 07/19/04

Next message: Panks: "Re: Tracking Data Changes"
Previous message: Claus Copenhagen: "RE: xp_cmdshell"
In reply to: Alex: "query help"
Next in thread: Alex: "Re: query help"
Reply: Alex: "Re: query help"
Messages sorted by: [ date ] [ thread ]

Date: Mon, 19 Jul 2004 07:50:29 -0500

The DDLs you posted does not seem right, no primary keys, no references and
too many NULL-able columns. How are the tables related to each other? What
are the keys?

Also, can you include sample data which you used to derive the expected
results you posted?

-- 
Anith

Next message: Panks: "Re: Tracking Data Changes"
Previous message: Claus Copenhagen: "RE: xp_cmdshell"
In reply to: Alex: "query help"
Next in thread: Alex: "Re: query help"
Reply: Alex: "Re: query help"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Which database design is better
... you can update primary keys because you can ... of employee. ... Remember that part in the specs in this thread about each store ... then I can use a REFERENCES clause. ...
(microsoft.public.sqlserver.programming)
Re: Best practice kinda question
... In the case of InvoiceLineItem I can get the CompanyID from the invoice ... it is a way to destroy data integrity and ... Natural primary keys are an old fashioned outdated idea, ... > REFERENCES Companies, ...
(microsoft.public.sqlserver.programming)
Re: Primary keys vs disallowing null values
... I'm assuming that Table2.FKA references Table1.PKA ... between 1)making both PKB and FKA the primary keys for Table 2 and ... records that have the same PKB value, as long as they all have different ... FKA values, and vice versa. ...
(microsoft.public.access.tablesdbdesign)