Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-09 : 13:56:20
|
Jay writes "Hi SQL guru, I am trying to select a record from a table, the sql for the query is as follows:
Select Company_Details.Company_ID
From Company_Details
Inner Join Company_Services
On Company_Services.Company_ID = Company_Details.Company_ID
Where Service_Type_ID = '4' And Service_Type_ID = '1'
However, even though the Company_Services table has two different records (Service_Type_ID = '4' And Service_Type_ID = '1') with the same Company_ID there are no records returned from the SQL query.
Is there any way I can get this to work?
Thanks" |
|
|
|
|
|
Select query with two or more search critieria from the same column in a table