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??
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.