Hey guys,
I am trying to figure out how to write this query.:banghead:
The data has a list of numbers and an address. One for business and one for Home. What I need is the business address....which would be easy but there are some that just have a home address.
So what I am trying to write is this:
Give all the numbers with business address
(here is where I am having trouble)
If it only has a home address show that.
example
Number | field1 | Address | City | State | Zip | Type |
---------------------------------------------------------------------
12345 | blah | 12 blah St | ORL | FL | 32804 | BSNSS |
12345 | blah | 58 floor St | ORL | FL | 32819 | HOME |
15648 | blah | 15 Red St | ORL | FL | 32804 | HOME |
So in this example I would return the first line and the 3rd line because the 1st one is a BSNSS and the 3rd only has a Home address
I have tried all kinds of stuff and have not gotten it yet
any ideas?
Thanks
I am trying to figure out how to write this query.:banghead:
The data has a list of numbers and an address. One for business and one for Home. What I need is the business address....which would be easy but there are some that just have a home address.
So what I am trying to write is this:
Give all the numbers with business address
(here is where I am having trouble)
If it only has a home address show that.
example
Number | field1 | Address | City | State | Zip | Type |
---------------------------------------------------------------------
12345 | blah | 12 blah St | ORL | FL | 32804 | BSNSS |
12345 | blah | 58 floor St | ORL | FL | 32819 | HOME |
15648 | blah | 15 Red St | ORL | FL | 32804 | HOME |
So in this example I would return the first line and the 3rd line because the 1st one is a BSNSS and the 3rd only has a Home address
I have tried all kinds of stuff and have not gotten it yet
any ideas?
Thanks