Results 1 to 2 of 2

Thread: sql request

  1. #1
    Join Date
    Jun 2003
    Posts
    20

    Unanswered: sql request

    I need your help on this:
    I want to create a sql query that placing all the data from tables , Name and Entrydate and only the data from the rest tables(ver,class,apos) that the name and date fields are in common with the tables Name and Entrydate. If for example for the name1 in 10/07/2003 got no value in Apos table I want a zero as result value??
    Is that possible??
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2003
    Posts
    20
    no,no this is wrong its not possible.
    forget about the Entrydate table, check this out ,
    select the first name in Names table and check if exist in the rest tables(ver,class,apos) , if yes then placing the fields totalver,totalclass,totalapos near to name if one of them not exist a zero value placing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •