Re: Query question?

From: "David Portas" <REMOVE_BEFORE_REPLYING_dportas@xxxxxxx>
Date: 25 Apr 2005 08:22:27 -0700

> but when T1.Id_T2=NULL there is a problem.

What problem? What do you want to happen when ID_T2 is NULL?

Maybe it's a LEFT JOIN you want? Change INNER JOIN to LEFT JOIN.

Better specs would help us with future questions. See:
http://www.aspfaq.com/etiquett e.asp?id=5006

--
David Portas
SQL Server MVP
--

.

Follow-Ups:
- Re: Query question?
  - From: xxxxyz@xxxxxx

References:
- Query question?
  - From: xxxxyz@xxxxxx

Prev by Date: Query question?
Next by Date: Re: Query question?
Previous by thread: Query question?
Next by thread: Re: Query question?
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL 2000, SP3a "TOP 100%"
... The best place to use ORDER BY is when you query the view. ... David Portas ... SQL Server MVP ... Prev by Date: ...
(microsoft.public.sqlserver)
Re: Price of SQL Server
... Workgroup Edition ... David Portas ... SQL Server MVP ... Prev by Date: ...
(microsoft.public.sqlserver.setup)
Re: datafile and log file on cluster
... files on separate physical disks. ... David Portas ... SQL Server MVP ... Prev by Date: ...
(microsoft.public.sqlserver.setup)
Re: How to connect to a dedicated m/c
... Windows 2003. ... David Portas ... SQL Server MVP ... Prev by Date: ...
(microsoft.public.sqlserver.connect)
Re: for updae trigger question
... I will try to generate the triggers that way so the ... >> Rather than write dynamic SQL into your production code why not write ... >> David Portas ... >> SQL Server MVP ...
(microsoft.public.sqlserver.programming)