Re: Simple Query Issues (Improved Grammer)
Re: Simple Query Issues (Improved Grammer)
- Subject: Re: Simple Query Issues (Improved Grammer)
- From: Brian Allen <email@hidden>
- Date: Sun, 30 Mar 2003 12:54:33 -0600
I have not been able to determine how to do some basic queries within
WebObjects that can be easily done using SQL.
For example, two tables A and B with a number of columns.
SELECT A.item1, A.item2, A.item3 FROM A,B WHERE A.item1 <> B.item1
The query should return all of 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.
Any suggestions?
_______________________________________________
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.