Re: SQL Query Building Problem??

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rik (rikleo2001_at_yahoo.com)
Date: 10/22/04 

Date: Fri, 22 Oct 2004 14:22:28 +1300

  Could Anybody please give me prompt reply?? I really need to fix that
problem urgently??

  TIA

  "Khurram" <s.khurram@gmail.com> wrote in message
news:urvUTkxtEHA.348@tk2msftngp13.phx.gbl...
>
>
> Hello Experts,
>
> I have problem while making a SQL Query.
> For Example:-
> I have three tables
>
> Table1 Table2(TaskDetail)
> Table3(Results)
> Task1 Status Task1-ID-1
> Task3-ID-1
> Task2 Status Task1-ID-2
> Task3 Status Task2-ID-1
> Task3-ID-1
>
> Now my requirement is that I want to know that Which Task has
received
> its
> Complete Results, like in the Above example Task3 is completed because,
> its
> TaskDetail = Table3(Results).
>
> I want help to build that query which will identify me that my
> Taskdetail
> are equal to Results.
>
> Thanks in Advance.
>
> Khurram
>
>
>

Relevant Pages

  • RE: Report is not being limited to specified collection
    ... Open up your SQL query for the actual report not the prompt and if you aren't ... > An example is that we have Mcafee antivirus on only a few of our servers on ...
    (microsoft.public.sms.inventory)
  • PAFileDB SQL Injection Vulnerability & Ratings Cheat Fix
    ... I recently found out that someone I knew was running this vuln ... After informing them it was vuln they were dissapointed at ... here is a quick fix i threw together to take care ... I also closed off the variable in the SQL query that was allowing the SQL ...
    (Bugtraq)
  • Re: How to convert Null values to zero when create an average query
    ... instead "2.5" because is not counting the null value date. ... How can I fix ... the SQL query so far is this: ... TRANSFORM AvgAS AvgOfTotal ...
    (microsoft.public.access.queries)
  • Re: Mysql count(condition)?
    ... Thanks for the prompt reply. ... How do i count how many people there are in each dept with an sql query? ... given the fact that i can sum the ... SELECT CountAS deptcount ...
    (comp.lang.php)
  • Parameters in Queries
    ... I am having a little trouble with an SQL query: ... 'Parameter' is simply a parameter which is entered in a prompt, ... name of the column in the 'Funds' table which the query is run against. ...
    (microsoft.public.access.queries)