Subselects with Relative tables

Subselects with Relative tables

Post by Pitoc » Thu, 22 Mar 2007 03:04:13


Guys,

I have a layer created in the ArcMap displaying some polygons and
there are some data linked to them. Besides that I have a table with
some extra data about these polygons.
These table was set as relate with the layer. My question is: there
is
a way where I can define a select specific to a polygon where in this
select I can create a sub select between the layer and these table.


Can someone tell me if it is possible?
 
 
 

1. Subselects with Relative tables

2. LIMIT in a subselect, but without using subselects


I'm using mysql v 4.0.something (so no subselects :( )

I have a table of shoppingcarts, and a table of cartitems. cartitems
have the cartuid of the shoppingcart they're in. Pretty simple, right?

if I do:

SELECT * from shoppingcarts left join cartitems on cartitems.cartuid=
shoppingcarts.uid LIMIT 50,10;

The LIMIT clause will be limiting the number of "rows" I get back in
the results (of course). What I *want* it to limit is the number of
"shoppingcarts" I get back. So I can make a tool that shows 10
shopping carts (with items in them) per page.

If I could do subselects, this is what the query would look like:

select * from shoppingcarts left join cartitems on cartitems.cartuid=
shoppingcarts.uid where shoppingcarts.uid in (select uid from
shoppingcarts order by created desc LIMIT 50,10);

(obviously that's untested since I can't do subselects on my mysql).

How can I do that with a left join instead? thanks

3. Mysql 4.0 without subselects, select 2 tables

4. Subselect from same table

5. Subselect from 2 tables from 2 different databases

6. Random via Subselect or Temporary Table

7. referencing the outermost table from an inner view which is inside a subselect

8. SubSelect of Table, rowIndex, sort and other fun

9. Help on update that subselects other records in table, uses joins

10. Avoiding Table Scan on Update with correlated subselect

11. convert relative paths to site root relative path?

12. doc relative and site relative links

13. document relative/site root relative linking

14. Dreamweaver goes to site root-relative paths instead of document relative

15. PHP: convert relative paths to site root relative path?