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
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
You wrote:
I apologize for asking such a basic SQL question, but I am failing in
finding
the solution...
Consider the following table:
id | option
---
1 | a
2 | a
2 | b
I want to find the ids with only a specific set of options.
For example, if I wanted to get the ids
I wrote:
I apologize for asking such a basic SQL question, but I am failing in finding
the solution...
Consider the following table:
id | option
---
1 | a
2 | a
2 | b
I want to find the ids with only a specific set of options.
For example, if I wanted to get the ids which have option
I apologize for asking such a basic SQL question, but I am failing in finding
the solution...
Consider the following table:
id | option
---
1 | a
2 | a
2 | b
I want to find the ids with only a specific set of options.
For example, if I wanted to get the ids which have option a only,
Does this work?
select t.id,t.option,t2.option from tableName t left join tableName t2 on
t.id=t2.id and t2.option!=t.option where t.option=a and isnull(t2.option);
HTH,
Jed
On the threshold of genius, [EMAIL PROTECTED] wrote:
I apologize for asking such a basic SQL question, but I am