Like Syntax error.

[nmmure]

Hi,

I am using SQL Server 2000. Below I am coping my SQl Query it is working fine.

Select A.account, C.customerName from account A
Join customerName c on C.customerno = a.customerno
where A.account = '10001147' and C.customerName '%A'

The above query is working fine. Customer names are availabe on another table Emp column name customerName.

Here I am trying pass CustomerName instead of A.
It is not showing any values. Pls correct my below SQl

Select A.account, C.customerName from account A
Join customerName c on C.customerno = a.customerno
Join Emp E on E.customername = c.customerName
where A.account = '10001147' and C.customerName like %' + @ E.customername + '

Pls help me.

Thanks
Mure

 

[jbenson001]

It would be helpful if you showed some sample data and desired output.

 

[bborissov]

Select A.account,
       C.customerName
from account A
Join customerName c on C.customerno = a.customerno
Join Emp E  on E.customername = c.customerName
where A.account = '10001147' and
      C.customerName like '%' + @E.customername

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[bborissov]

W/o @ in front of E.CusttomerName:

Select A.account,
       C.customerName
from account A
Join customerName c on C.customerno = a.customerno
Join Emp E  on E.customername = c.customerName
where A.account = '10001147' and
      C.customerName like '%' + E.customername

Also what types are both field:
customerName.customerName
and
Emp.customerName


Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[nmmure]

Hi,
My First Query will display following Records

10001147 Antony
10001147 Anand

Using Like %A it is showing above records.

same account 10001147 will have some Names starting other Alfabytes. I need to pull the names, those names are available in Emp table, I trying to pass E.customername instead of A.

Pls correct me my SQl statement.

Expected output was. these name are available on Emp table

10001147 Antony
10001147 Anand
10001147 Elegen
10001147 Flan
10001147 John
10001147 Jack
10001147 Piper
10001147 Susanti

Thanks
Mure

 

[nmmure]

I am appreciating your help. Thanks bborissov.

My Query is working fine.

Thanks
Mure

 

[bborissov]

Mure,
I am totally confused here. Can you provide some simple data and desired result?

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[jbenson001]

You don't need the where C.customerName like '%' + E.customername if you are already joining on those columns

 

[bborissov]

Good catch, jbenson001
I even didn't saw this

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[jbenson001]

LOL.. no problem...

 

[nmmure]

Yes, your right jbenson001.

Thanks.
Mure