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 Chriss Miller 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. janne11

    SQL help!

    Thanks, this worked perfectly (needed + syntax due to other such joins in the not-simplified query) select orders.name, orders.country, orders.postcode, nvl(charges.charge,30) from orders, charges where orders.country = charges.country (+) and postcode >= lowpc (+) and...
  2. janne11

    SQL help!

    Oh, this worked: select orders.name, orders.country, orders.postcode, charges.charge from orders left outer join charges on orders.country = charges.country and postcode between lowpc and highpc Will figure out later why... How about the default value? This gives...
  3. janne11

    SQL help!

    Thanks, I have been playing around with outer joins but without luck. For example, select orders.name, orders.country, orders.postcode, charges.charge from orders, charges where orders.country = charges.country(+) and postcode between lowpc and highpc(+) This did no...
  4. janne11

    SQL help!

    Apologies for this probable newbie question! Given table orders id name country postcode --------------------------- 1 A NL 1330 2 A NL 7320 3 B NL 002100 4 C CZ 13005 5 D GB AB3 table charges country lowpc highpc charge...
  5. janne11

    SQL query question...

    hoinz: Its YYYYMMDD so should be ok with min. Dagon: Thanks, interesting! Ill try it out now. It is actually a more complicated query, it should also get the highest date where code is X,Y,Z and a few more things. But this gives me something to start with!
  6. janne11

    SQL query question...

    Thanks, unfortunately I simplified the example too much. Need more data from PACKAGE table. So the result should be something like RESULTSET id desc date ---------------------- 1 aaaaaa 20070103 (code A) 2 bbbbbb 20070106 (code C) 3 cccccc 20070108 (code A and B)...
  7. janne11

    SQL query question...

    Hi, I was hoping someone here is able to help me out, more of a general SQL query maybe but it is on a 10g database! Some what simplified I have two tables: PACKAGES id name desc ---------------------- 1 namea aaaaaa 2 nameb bbbbbb 3 namec cccccc 4 named...

Part and Inventory Search

Back
Top