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 |
|
kt
Yak Posting Veteran
88 Posts |
 Posted - 2014-03-26 : 12:01:34
|
| Hi,I want to find the if any supplierNo from tbl_system are in the subquery, but keep gettingIncorrect syntax near the keyword 'select'.Incorrect syntax near ')'thanksselect distinct supplierNo from tbl_systemwhere exits ( select a.t_otbp as "LN_S", b.t_seak as "MK_S" from ttdpur400863 a left join ttccom100700 b on b.t_bpid = a.t_otbp ) |
|
|
bitsmed
Aged Yak Warrior
545 Posts |
Posted - 2014-03-26 : 12:13:34
|
| exiSts |
 |
|
|
|
|
|
syntax- pls help