First time I've ever done anything like querying 2 tables at a time, and I'm struggling. I have the following query

SELECT
categories.id,
categories.listing,
categories.catname,
subcategories.catid,
subcategories.subcat,
subcategories.listings,
subcategories.url
FROM
categories
LEFT JOIN
subcategories
ON
categories.id=subcategories.catid
ORDER BY
categories.catname,subcategories.subcat
ASC


I am wanting to only show 3 results at a time from subcategories table. I tried adding LIMIT to the end of the query, but that just limited both tables.

Two separate queries using a UNION ALL to join the queries.

cheers for that :)

you may prefer to write the query in that sort of format but you can save typing time by using an 'alias'

eg


SELECT
c.id,
c.listing,
c.catname,
s.catid,
s.subcat,
s.listings,
s.url
FROM
categories AS c
LEFT JOIN
subcategories AS s
ON
c.id=s.catid
ORDER BY
c.catname,s.subcat
ASC



and I find this helps with 'seeing' where commas have run away and hidden somewhere.


SELECT
c.id
, c.listing
, c.catname
, s.catid
, s.subcat
, s.listings
, s.url
FROM
categories AS c
LEFT JOIN
subcategories AS s
ON
c.id=s.catid
ORDER BY
c.catname,s.subcat
ASC

Cheers for that, didn't know about the alias thing