Select * from (SELECT [Uid],[sourceid],[postcode],[latitude],[longitude],[propertyType],[beds],[displayAddress],[current_price],[current_status],[sale_or_rental],[District] FROM [DATA_EXPORT].[dbo].[RM_REPORT_TODAY] where sale_or_rental=1 union all SELECT [Uid],[sourceid],[postcode],[latitude],[longitude],[property_type],[beds],[displayAddress],[price] as current_price,[listing_status] as current_status ,[sale_or_rental],[District] FROM [DATA_EXPORT].[dbo].[Z_REPORT_TODAY] where sale_or_rental=1) t1 where postcode='KY7 6WU'
KY7 6WU - 210,000
- Bungalows
- Right Move
KY7 6WU - 339,000
- Bungalows
- Right Move
KY7 6WU - 250,000
- Semi-Detached Bungalow
- Right Move
KY7 6WU - 210,000
- Bungalows
- Right Move
KY7 6WU - 210,000
- Bungalows
- Right Move
KY7 6WU - 410,000
- Bungalows
- Right Move
KY7 6WU - 210,000
- Bungalows
- Right Move
KY7 6WU - 425,995
- Bungalows
- Right Move
KY7 6WU - 250,000
- semi_detached_bungalow
- Zoopla
KY7 6WU - 210,000
- semi_detached_bungalow
- Zoopla
KY7 6WU - 410,000
- detached_bungalow
- Zoopla