Search found 1 match
- Tue Nov 21, 2017 11:46 am
- Forum: Vertica SQL
- Topic: Subqueries in the ON clause are not supported
- Replies: 5
- Views: 27863
Re: Subqueries in the ON clause are not supported
Hi I try to throw query select client_id, si, brand_id, px, py, pz, sc, test, apMac, la, lo, time_stamp from wfa_4.dim_client inner join wfa_4.raw_data_with_json on mp =( select store_mp_id from wfa_4.dim_store where id = 7) and si = client ERROR SQL Error [4816] [0A000]: [Vertica][VJDBC](4816) ERRO...