You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
sql->whit tmp_auth as (select node_id, node_type from xxx.xxx.organization where status = '1' and node_type <> '0')
select t1.id, t2.name from xxx.xxx.test1 t1 left jon xxx.xxx.test2 t2 on t1.id = t2.o_id and t1.s_id in (select node_id from tmp_auth where node_id = 1) limit 10;
error message -> Column 't1.s_id' cannot be resolved
The text was updated successfully, but these errors were encountered:
whit tmp_auth as (select node_id, node_type from xxx.xxx.organization where status = '1' and node_type <> '0')
select t1.id, t2.name from xxx.xxx.test1 t1 left jon xxx.xxx.test2 t2 on t1.id = t2.o_id and t1.s_id in (‘1’, ‘2’) limit 10;
sql->whit tmp_auth as (select node_id, node_type from xxx.xxx.organization where status = '1' and node_type <> '0')
select t1.id, t2.name from xxx.xxx.test1 t1 left jon xxx.xxx.test2 t2 on t1.id = t2.o_id and t1.s_id in (select node_id from tmp_auth where node_id = 1) limit 10;
error message -> Column 't1.s_id' cannot be resolved
The text was updated successfully, but these errors were encountered: