Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
abhijitklg
Starting Member
1 Post |
Posted - 2013-09-11 : 05:15:19
|
Sir, I have two tables as follows,TABLE A GROUP STARTACCNO ENDACCNO A 100 999 B 1000 3000TABLE B ACCNO GROUP 230 A 500 A 1000 B 300 A 100 A 2500 B 3000 B My Requirement is as follows,SELECT B.*CASEIF B.ACCNO BETWEEN A.STARTACCNO AND A.ENDACCNO AND B.GROUP = A.GROUP THEN ‘OK’ ELSE ‘PLEASE CHECK’Sir please guide how to achieve this. |
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-09-11 : 07:23:56
|
SELECT B.*, A.*, CASE WHEN B.ACCNO BETWEEN A.STARTACCNO AND A.ENDACCNO THEN 'OK' ELSE 'Check' ENDFROM TABLEA ALEFT JOIN TABLEB B ON B.[GROUP] = A.[GROUP]--Chandu |
|
|
|
|
|