On Sep 18, 5:41 pm, daniel_spaniel <[email protected]> wrote: > One more thing, I tested on mysql and it was fine, but the other db i > am using does not like the sql like: > > SELECT * FROM "TRIP PASSENGERS" > WHERE (("KID - DATE", "KID - TIME", "KID - USER", "KID - MULT", "KID > - COMM")) IN ((39350,764,4,0,17),(39829,10,20,3,4))
Which database doesn't like that? > it prefers > > SELECT * FROM "TRIP PASSENGERS" > WHERE "KID - DATE" IN (39350,39829) and > "KID - TIME" IN (764,10) and > "KID - USER" IN (4,20) and > "KID - MULT" IN (0,3) and > "KID - COMM" IN (17,4) > > is there a way to switch to that style somehow? That style is incorrect (it selects rows that don't match), so no. Jeremy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
