Re: Tool to check why queries miss results?

Andreas Koch wrote:
> Hi all,
>
> just a strange idea. Is there some tool that takes
> an SQL query, plus (parts) of an output of that query
> you'd expect to see, and then explains why that part
> of output wasn't created?
>
> -----------------------------
> Example:
>
> SELECT cty.CityName, cust.Name, bsy.Business
> FROM City cty, Customer cust, Business bsy
> WHERE cust.zip=cty.zip and cust.bsyid=bsy.bsyid;
>
> Returns:
> New York,Jim, Food
> Tokie, Jo, Film
>
> Expected : CityName=London, Name=*, Business=*

[Quoted] And why would any person expect London much less a tool.

[Quoted] If someone doesn't have the requisite skills to write a SQL statement they should just learn how to say "Do you want fries with that?"

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)