Select value from table, find information between in another table

Question

question

Gogolo asked Feb 16, '16

Select value from table, find information between in another table

I need to find information on second table, where the selected value from first table belong. In second table are stored only starting serial number and ending serial number. example: SELECT num1 FROM tbl1 WHERE num1 IN ( SELECT * FROM tbl2 WHERE num1 BETWEEN firstSerialNo AND lastSerialNo )

select sql server 2008 r2 between

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

seanlange commented · Feb 16, 2016 at 02:05 PM

As posted there is not a lot of chance for people to answer this. Can you provide some details about what you are trying to do?

0 ·

Answer 1 · 2016-02-18T12:08:47Z

GPO answered Feb 18, '16

(making a lot of assumptions here, but I hope I can get you started nevertheless) What about: SELECT tbl1.num1 ,tbl2.firstSerialNo ,tbl2.lastSerialNo FROM tbl1 LEFT JOIN tbl2 ON tbl1.num1 between tbl2.firstSerialNo AND tbl2.lastSerialNo ;

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question