Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.
Insert into LookupTable Select distinct A.AID, A.BID, A.CID From ImportTable I left outer Join LookupTable A on A.AID = I.AID where 1=1 and A.AID is null and I.BID <> ''
|Union 2 queries to a cte (temp table perhaps)||9||34|
|SQL Querying data from 3 tables, all with 1 common column||4||32|
|Can > be used for a Text field||6||33|
|Query Doesn't Allow New Records to be Added When Linked to SQL Server Backend||4||20|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!