• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Simple Query Issues
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Simple Query Issues


  • Subject: Simple Query Issues
  • From: Brian Allen <email@hidden>
  • Date: Sun, 30 Mar 2003 12:42:10 -0600

I am have not been able to determine how to do some basic queries within
WebObjects that be easily done using SQL.

For example, two tables A and B.

SELECT A.item1, A.item2, A.item3 FROM A,B WHERE A.item1 <> B.item1

This should return all the records within table A that did not have any
matches between the A.item1s and the B.item1s.


I saw that I could type this as SQL within EOModeler, but WO or EOModeler
should have this a basic capability.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.

  • Follow-Ups:
    • Re: Simple Query Issues (Improved Grammer)
      • From: Brian Allen <email@hidden>
  • Prev by Date: Re: Third Party Jar - Regular Expression Pattern
  • Next by Date: Re: Simple Query Issues (Improved Grammer)
  • Previous by thread: PBX doesn't like seventies
  • Next by thread: Re: Simple Query Issues (Improved Grammer)
  • Index(es):
    • Date
    • Thread