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...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.
Continue discussion
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...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.