Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: mastermonster
- Order by date
-
Problem with IN and WHERE
Thanks for message, it returns all value in "dagitimYeri" but now I have another problem, All SUM(....) value in one row is same and their value is so big, how can I solve this?- mastermonster
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Problem with IN and WHERE
I have a Access 2000 database, but I don't know SQL so much. My query is above and sorry for table and column names are not english.... SELECT d.adi as Adi, SUM(c1.tutar) as t1,SUM(c2.tutar) as t2, SUM(c3.tutar) as t3 FROM ( ( ( ( ( dagitimYeri as d LEFT JOIN cikislar as c1 ON c1.dagitimYeri =...- mastermonster
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
