Re: Need help with a sql query

Imran wrote: Hello all: > ... I would like to get all of the records in MenuOptions and any record in MenuAccess with a specific fkGroupid. For example: ... > IIf I run a query for fkgroupid = 1 I should get AccessId fkMenuID fkgroupid view execute Me

Need help with a sql query

Hello all: I have two tables: 1. MenuAccess: accessId fkMenuId fkGroupid View Execute 2. MenuOptions MenuId MenuName I would like to get all of the records in MenuOptions and any record in MenuAccess with a specific fkGroupid. For example: A. MenuAccess AccessId