Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
I want combine two query
SELECT [id],[dataNvarchar]
FROM [razborka].[dbo].[cmsPropertyData]
WHERE propertytypeid=92 and [dataNvarchar] IS NOT NULL
SELECT [id],[dataInt]
WHERE propertytypeid=30 and [dataInt] IS NOT NULL
But I dont know how, can you help?
Result
id |||||||| dataNvarchar |||||||||| dataInt
Do you want a Union or Join?
let me know
-Rajeev
is working on a reply...
Write your reply to:
Upload image
Image will be uploaded when post is submitted
Can you help with SQL?
I want combine two query
SELECT [id],[dataNvarchar]
FROM [razborka].[dbo].[cmsPropertyData]
WHERE propertytypeid=92 and [dataNvarchar] IS NOT NULL
SELECT [id],[dataInt]
FROM [razborka].[dbo].[cmsPropertyData]
WHERE propertytypeid=30 and [dataInt] IS NOT NULL
But I dont know how, can you help?
Result
id |||||||| dataNvarchar |||||||||| dataInt
Do you want a Union or Join?
let me know
-Rajeev
is working on a reply...