hey guys, you were very helpful teh last time i reached out to you and maybe you acn help me this time also.
I know it must be very simple but at this moment im stuck.
i have 2 tables:table A and table B. i need to populate the final table with data from table A based on table B.
i need to copy the rows from table A with the condition that the ID='default' for both tables
and column count =1 from table B.
final table is a temporary table for me
this si what i have so far and it doesnt work:
select t1 ID,
t1 Org ID into #final table
from table A inner join table B
where t2 ID='default' and t2 Count=1
it gives me an error: Incorrect syntax near the keyword 'where'