By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,282 Members | 1,736 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,282 IT Pros & Developers. It's quick & easy.

Like operator Multiple inputs.

P: 25
Hi, I want to use the like operator with multiple inputs but get an error

This is wat i am doing

Select x,y,z from tableA
Group by x,y,z
Having x like(Select * from tableB)


table B has just one coloumn with string patterns.

If i do not use a sub query and just use a sub pattern like[] it works, but i need to compare multiople inputs

Any clue any one
Oct 6 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
Hi,

Try

Select x,y,z from tableA
Group by x,y,z
Having x in (Select Yourfield from tableB)


:)

Hi, I want to use the like operator with multiple inputs but get an error

This is wat i am doing

Select x,y,z from tableA
Group by x,y,z
Having x like(Select * from tableB)


table B has just one coloumn with string patterns.

If i do not use a sub query and just use a sub pattern like[] it works, but i need to compare multiople inputs

Any clue any one
Oct 8 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.