Re: Simple Query Issues
Re: Simple Query Issues
- Subject: Re: Simple Query Issues
- From: Ray Ackland <email@hidden>
- Date: Tue, 1 Apr 2003 09:28:55 +1200
Brian,
I am just learning sql myself so I hope I don't put you wrong, but I
imagine that query would return all the combinations of the rows in
table A and B where the "item1s" don't match (ie lots of rows returned).
I believe what you are after is to do something similar (sql syntax not
right):
SELECT A. item1, A. item2, A. item3 FROM table1 A, table2 B WHERE A.
item1 = B. item1 and B. item1 = null.
I expect that you will need to include in there some stuff about outer
(left?) joins around the WHERE part.
I know this isn't a complete answer, but should steer you in the right
direction.
Ray.
On Monday, Mar 31, 2003, at 18:01 Pacific/Auckland,
email@hidden wrote:
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.
_______________________________________________
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.