correction in sql code.

	Home Register Search Help Login

Sponsors

Hosting from $3.99 per month!

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions. dd

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

correction in sql code.

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> correction in sql code.

Page: [1]


s2bn1 Posts: 192 Joined: 2/2/2002 From: Dubai United Arab Emirates Status: offline	correction in sql code. - 12/11/2006 6:06:42 Could anyone help me in correcting my sql code, I got 2 different tables for 1) registration 2)renewals same client will be having all the three cases filed.I want to count total no. of cases for a client . So I wrote the sql as below which gives me an eror SUM(SELECT COUNT(id) AS Expr1 FROM renewal where client_name='::client_name::'+ SELECT COUNT(id) AS Expr1 FROM registration where client_name='::client_name::') Thanks a lot