getting error of <

Aseem Bhardwaj

10y1k

SELECT Gledger.*,

CAST('' AS DECIMAL(5,0)) as sno ,

00000000000000.00 AS BALANCE ,

SPACE(5) AS DC ,

ISNULL(master.ma_AcName,'') as ma_AcName,

master.PK_ID

FROM Gledger LEFT JOIN master ON

Gledger.Gl_AcId = master.pk_id

WHERE gledger.Gl_AcId = <>

and Gledger.Gl_Date between '<>' and '<>'

and LEFT(Gledger.gl_voucher,2) <>

and <>

ORDER BY gledger.gl_date

this is my query please help and give me optimal solution.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Aseem Bhardwaj10y ago
Actually client gave me this code to use as left join
and he is confused so i am also being perplexed. i made gledger table master table now trying to join them in grid view. i don't how can i use <> or whatever in this<<>>.
i develop stored procedures just to insert update and delete .
in master only pk_id and ma_Acname exists. and in glegder these are the columns
Gl_AcId1]
,[Gl_AcId]
,[Gl_Narration]
,[Gl_Drcr]
,[Gl_Date
i will align gledger with master then i need joins. which is simple but client wants only this query
i don't know how to use it.
i am in trouble................... don't know what to do???
Bikesh Srivastava10y ago
Hi,
use this code.
SELECTGledger.*,
CAST(''ASDECIMAL(5,0))assno,
00000000000000.00ASBALANCE,
SPACE(5)ASDC,
ISNULL(master.ma_AcName,'')asma_AcName,
master.PK_ID
FROMGledgerLEFTJOINmasterON
Gledger.Gl_AcId=master.pk_id
WHEREgledger.Gl_AcId=THISFORM.ACID
andGledger.Gl_Datebetween'<>'and'<>'
andLEFT(Gledger.gl_voucher,2)m.ltyPe
andIIF(thisform.container1.check1.Value,'gledger.gl_voucher!="O"','1=1')
ORDERBYgledger.gl_date
can you let me know what is use of <> this tag in sql.????????
Midhun Tp10y ago
Is it a stored procedure?
Parameters will be like @param1
You can just assign as gledger.Gl_AcId = @param1
Aseem Bhardwaj10y ago
<> is parameters i dont know how to use this parameter. can you suggest how can i use it???
Pradeep Shet10y ago
Can you help us understanding where exactly you are writing the query
Midhun Tp10y ago
Hi,
I assume you are running this query in sql server. Can you please tell for what purpose<<THISFORM.ACID>> is used for?