Developer Forum

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?