Oops I got it... Have googled it

Thanku so much again

Awesome I got my output..

But can u explain me ur code...

I haven't come across charindex before... What does it do???

Perfect.... I got the result now.....Thanku again Sean...

select

Customer.CustomerID, (case when Customer.CustomerID >3 then Orders.PONumber else cast(Orders.OrderID AS varchar) end) as 'PONumber/OrderID'

from

Customer

inner join CustomerOrders on Customer.CustomerID =CustomerOrders.CustomerID

inner join...

BriPan (10/28/2012)

---

Try this One

select

* -- What ever column you want

,(case when Customer.CustomerID >3 then Order.PO else Order.OrderID end) as 'PO/OrderID'

from

Customer

inner join CustomerOrders on Customer.CustomerID =CustomerOrders.CustomerID

inner join Order on...

Thanks for the reply I tried using this and got some error

Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the nvarchar value 'Verbal' to data type...

Hey Thanku 🙂

I got it

SELECT Customer.CustomerName, Count(customerorders.customerID) AS Count

FROM Customer

JOIN CustomerOrders ON (Customer.CustomerID= CustomerOrders.CustomerID)

Group By CustomerName

So I get to use joins concept along with the group by clause in this case as i am going to use two differnt tables??? Not a question to you......

For the same data Provide the SQL statement that would return every CustomerName and the count of orders they have ever placed.

I have tried using the below code

select Customer.CustomerName,...

Thanku Jeff