Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DiscoStuart

    Need Help Shortening WHERE Clause Currently over 255 Characters

    Hi, Why not use the UNION clause to split your query into two or more select statements. e.g. select record_id from editorial_sub8 where a1 like'%|He%' or a1 like'%|Ent B%' or a1 like'%|Fin B%' or a1 like'%|Music B%' or a1 like'%|News B%' union all select record_id from editorial_sub8...
  2. DiscoStuart

    WHERE EXISTS vs. LEFT OUTER JOIN vs. IN(..) Statement

    I think I have figured out the cause of this problem. It's because there was a NULL value for the 'PlslID' in table dba.tblImpPrimusTemp. Once I removed this record the third query gave me the same results as the first two queries. It must have something to do with the way NULLs are treated...
  3. DiscoStuart

    WHERE EXISTS vs. LEFT OUTER JOIN vs. IN(..) Statement

    Hi, Here are the table structures: create table dbz.tblMyrAllCompleted(jobid int); create table dbz.tblAllPrimusPlac( PlslID int, Category char(30), Department char(30), ordid int, jobid int, costcentre int); create table dba.tblImpPrimusTemp( PlslID int, invoice_no int, ItemName char(30)...
  4. DiscoStuart

    WHERE EXISTS vs. LEFT OUTER JOIN vs. IN(..) Statement

    I executed the following three SQL statements. The first two produced identical results, but the last one returned no results, can somebody please tell me why? select b.plslid from dbz.tblMyrAllCompleted a inner join dbz.tblallprimusplac b on a.jobid=b.jobid where not exists (select z.plslid...

Part and Inventory Search

Back
Top