Query multiple fields in same table.

[peterbata]

Table looks like this:

custno custname qty active banner

My simple query so far looks like this:

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT ALL[custno]
      ,[custname]
      ,[qty]
      ,[active]
      ,[banner]
  FROM [mydatabase].[dbo].[subscribe]
  WHERE qty > 1 AND active = 1 AND banner = '99'

I have a total of nine banners eg. 13, 06, 18, etc

How would I choose to display the results of several banners of my choosing? Thank you in advance. Peter

[ck9663]

Join the table to itself. Just use a different alias for each.

Happy Coding!!!


~~ CK

[peterbata]

Thank you for the prompt reply. Much appreciated. As a noob, all I have to do now is figure out how to implement your suggestion. Have a good one! Peter