Re: problem in SQL

Hi. On Tue, Nov 20, 2001 at 11:38:01AM +0530, [EMAIL PROTECTED] wrote: > Hello, > > I have a problem related SQL Query > > SELECT a.cAction_Name,a.nAction_ID FROM tbl_actionmaster a LEFT JOIN > tbl_roleactionrelation b ON a.nAction_ID != b.nAction_ID > WHERE b.nRole_ID = 3 > group by a.cAct

problem in SQL

Hello, I have a problem related SQL Query SELECT a.cAction_Name,a.nAction_ID FROM tbl_actionmaster a LEFT JOIN tbl_roleactionrelation b ON a.nAction_ID != b.nAction_ID WHERE b.nRole_ID = 3 group by a.cAction_Name In this query i wants to find Action name and Action Id from the Action Master