Simple join

[LesStockton]

What's wrong with the join in this stored procedure I'm trying to write?

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[udCount_OrdersNew]
@OrderOwnerCompany int
AS
SELECT
Count(OrderID) AS Count
FROM [T_Order O] JOIN [T_OrderStatus OS]
WHERE O.OwnerCompany = @OrderOwnerCompany
AND O.ReviewedInd = 0
AND OS.Description='New'

 

[jbenson001]

remove the alias from the []. It thinks they names of the tables are T_Order O and T_OrderStatus OS
Also you don't need the []s/

FROM T_Order O Join T_OrderStatus OS

Jim

 

[SQLDenis]

where is your join condition??????

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[udCount_OrdersNew]
    @OrderOwnerCompany int
AS
SELECT 
    Count(OrderID) AS Count
FROM T_Order O JOIN T_OrderStatus OS 
on o.OwnerCompany  =os.OwnerCompany  -- is this the correct join??
WHERE O.OwnerCompany = @OrderOwnerCompany
     AND O.ReviewedInd = 0
     AND OS.Description='New'

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[jbenson001]

Ah good point Denis.. I missed that