Can anyone help with this query?

[itbeings]

I want to return a distinct Main Category from the 'mcat' table with it Sub-Categories from the 'scat' table but am getting online one sub-category returned. Any one ?

SELECT DISTINCT mc.mcatID, mc.mcatName, sc.scatID, sc.scatName FROM mcat mc
INNER JOIN scat sc
ON mc.mcatID = sc.mcatID

[potterd64]

probably something wrong with your tables. The query looks fine, and should work as long as the tables are setup correctly. There are supposed to be multiple sub category entries per main category entries right?

[Phill Pafford]

I think its your SELECT DISTINCT, this should only return one record and in the statement it reads for all the tables.

[itbeings]

All I want to do is get a main category and it's sub categories returned in a single query. On the sub-category table, I have the main category PK(mcatID) as FK(mcatID). All I want is just a single Main Cat.. and all its sub cat returned.