Column in where is ambiguous

A bit of a learning curve. Still, this beats the previous method which was using roughly excel spreadsheets. Does it matter if the industries are not based on single values? In short, on the report where this ends up they are grouped together. There are 24 per area county and between 25 to 32 2-digit versions of the naicscode. To continue this discussion, please ask a new question. Spiceworks Help Desk. The help desk software for IT.

Track users' IT needs, easily, and with only the features you need. Learn More ». Get answers from your peers along with millions of IT pros who visit Spiceworks. The query below returns correct data. However, it queries the entire table 80k rows Text. Best Answer. Alec This person is a verified professional. Verify your account to enable IT peers to see that you are a professional. Microsoft SQL Server expert.

Try the following: SQL. View this "Best Answer" in the replies below ». Thai Pepper. Homer T. I got good point from John, however I do not much agree to vote such a question even with very clear contents. Until the question seems bit worthy or special. Ahmet Arslan Ahmet Arslan 4, 1 1 gold badge 26 26 silver badges 30 30 bronze badges.

This is the most simple of all the answers. VendorName, i. InvoiceID, iL. InvoiceSequence, iL. Nelson Katale Nelson Katale 11 11 silver badges 18 18 bronze badges. Junior Placido Junior Placido 31 2 2 bronze badges. It doesn't just happen in queries with joins. Dave Pile Dave Pile 4, 3 3 gold badges 30 30 silver badges 47 47 bronze badges.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Awesome thank you, thank you! This is more related to building a SQL report for the spiceworks reporting system.

CesarM wrote: So what changes can I make to update the join statement to reflect the Admin table. Sorry, I don't follow what you are asking. What 'Admin' table? Try this: SQL. This topic has been locked by an administrator and is no longer open for commenting. Read these next Regular Visitor. Frequent Visitor. The order of the operations could provide a solution. New Member. Completed Ideas. What does "Via Api" mean? Forgot to update version in About page? We couldn't authenticate with the credentials prov View All.

Latest Comments.