SELECT * FROM userLogon b full join LogNoReport l on b.id=l.Requested_by
full outer join DetailLog u on l.RFQNo=u.LogNoN
WHERE(id = @id OR @id IS NULL)
ORDER BY No DESC
Tag : ASP, MySQL, Ms SQL Server 2008, Web (ASP.NET), C#
Date :
2018-01-19 22:59:50
By :
enynina
View :
1081
Reply :
1
No. 1
Guest
Code (SQL)
SELECT RFQNo,max(No) FROM userLogon b full join LogNoReport l on b.id=l.Requested_by
full outer join DetailLog u on l.RFQNo=u.LogNoN
WHERE(id = @id OR @id IS NULL)
GROUP BY RFQNo
ORDER BY No DESC