how select that where =list

select NameCompany fro开发者_Go百科m [ParticipateFairList] 
where IdFair=(select Id from [TmpFair] where Parent_FK=88)

This is Correct?

how

For Select * From [Table] where ID=`List` or `SubQuery`

select NameCompany from [ParticipateFairList] 
where IdFair in (select Id from [TmpFair] where Parent_FK=88)

where IdFair in (...) instead of where IdFair =(...)

For MySQL or SQL Server, you want expr IN (list | subquery).