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 TouchToneTommy 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: *

  • Users: Smulan
  • Content: Threads
  • Order by date
  1. Smulan

    Join three tables, getting the rows with at least one match

    Hi I want to join three tables, Lets say A, B and C. I want all data from the A table that have at least one row matching in B or C. That Is I dont want the rows from A that do not have an match in eiter B or C, but all the other. Now the Query looks a bit like this. Which gives me the wrong...
  2. Smulan

    Comparing two date intervals that can have endate=null

    How do I compare two dateintervals (from-to date), the first intervall should be either fully or partly within the second date intervall, and in both intervals the enddate can be NULL. Do not want to set the Null dates to an imaginary date if this can be avoided. Can it be done by SQL not using...

Part and Inventory Search

Back
Top