Click here to Skip to main content
15,914,905 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionAdding fields to CreateUserWizard control (v 2.0)?? Pin
Goalie3516-Jul-07 4:49
Goalie3516-Jul-07 4:49 
QuestionUser Details when using Login Component Pin
totocaster16-Jul-07 4:10
totocaster16-Jul-07 4:10 
AnswerRe: User Details when using Login Component [modified] Pin
ezazazel16-Jul-07 9:57
ezazazel16-Jul-07 9:57 
QuestionInstalling IIS Pin
ciacia16-Jul-07 4:03
ciacia16-Jul-07 4:03 
AnswerRe: Installing IIS Pin
N a v a n e e t h16-Jul-07 4:43
N a v a n e e t h16-Jul-07 4:43 
AnswerRe: Installing IIS Pin
Vasudevan Deepak Kumar16-Jul-07 7:51
Vasudevan Deepak Kumar16-Jul-07 7:51 
AnswerRe: Installing IIS Pin
Paul Conrad16-Jul-07 9:58
professionalPaul Conrad16-Jul-07 9:58 
QuestionDistinct in Query Pin
Khan.Bangash16-Jul-07 3:59
Khan.Bangash16-Jul-07 3:59 
Hi All
What is wrong in this Query I want only one record of a customer. If he have many records.
If I remove the othere tables from the queyr then it works fine.

SELECT DISTINCT cust_order.customer_id AS cust_id, cust_order.order_id AS order_id, customers.fname AS fname, customers.lname AS lname, cust_order.order_date AS order_date, cust_order.order_status AS order_status
FROM cust_order, customers, cust_debit
WHERE customers.customer_id=cust_order.customer_id and cust_order.order_id = cust_debit.order_id and cust_debit.amount >=2000;

pls help me.
Thanks in Advance.
AnswerWrong forum Pin
leckey16-Jul-07 4:01
leckey16-Jul-07 4:01 
GeneralRe: Wrong forum Pin
Paul Conrad16-Jul-07 9:59
professionalPaul Conrad16-Jul-07 9:59 
GeneralRe: Wrong forum Pin
leckey16-Jul-07 10:35
leckey16-Jul-07 10:35 
GeneralRe: Wrong forum Pin
Paul Conrad16-Jul-07 10:53
professionalPaul Conrad16-Jul-07 10:53 
AnswerRe: Distinct in Query Pin
Vasudevan Deepak Kumar16-Jul-07 7:52
Vasudevan Deepak Kumar16-Jul-07 7:52 
QuestionCss dilemmas Pin
matjame16-Jul-07 3:44
matjame16-Jul-07 3:44 
AnswerRe: Css dilemmas Pin
Scott McFadden16-Jul-07 3:54
Scott McFadden16-Jul-07 3:54 
GeneralRe: Css dilemmas Pin
matjame16-Jul-07 4:00
matjame16-Jul-07 4:00 
GeneralRe: Css dilemmas Pin
Scott McFadden16-Jul-07 4:06
Scott McFadden16-Jul-07 4:06 
GeneralRe: Css dilemmas Pin
matjame16-Jul-07 4:11
matjame16-Jul-07 4:11 
GeneralRe: Css dilemmas Pin
Scott McFadden16-Jul-07 4:40
Scott McFadden16-Jul-07 4:40 
QuestionShowModalDialog with XP Pin
peacefulmember16-Jul-07 2:59
peacefulmember16-Jul-07 2:59 
AnswerRe: ShowModalDialog with XP Pin
Vasudevan Deepak Kumar16-Jul-07 7:53
Vasudevan Deepak Kumar16-Jul-07 7:53 
Questionasp.net Pin
Rasal doss Solomon16-Jul-07 2:57
Rasal doss Solomon16-Jul-07 2:57 
AnswerRe: asp.net Pin
Sathesh Sakthivel16-Jul-07 3:00
Sathesh Sakthivel16-Jul-07 3:00 
GeneralRe: asp.net Pin
Vasudevan Deepak Kumar16-Jul-07 7:54
Vasudevan Deepak Kumar16-Jul-07 7:54 
AnswerRe: asp.net Pin
Paddy Boyd16-Jul-07 3:12
Paddy Boyd16-Jul-07 3:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.