4,707 questions
Why wouldn't it? If you have a concrete example, we can surely help you.
Query SQL Server graph data with relational data
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 75%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
moondaddy
916
Reputation points
Using SQL Server 2019, is it possible to query both graph data and relational data in the same query?
Developer technologies Transact-SQL
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 52%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
LiHong-MSFT 10,056 Reputation points2022-03-15T07:33:17.77+00:00 Hi @moondaddy
Could you please share us your table structure (CREATE TABLE …) and some sample data(INSERT INTO …) along with your expected result? So that we’ll get a right direction and make some test.Best regards,
LiHong
Sign in to comment
2 answers
Sort by: Most helpful
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2022-03-13T21:13:08.147+00:00 -
moondaddy 916 Reputation points
2022-03-13T21:17:53.64+00:00 the answer is yes
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
2022-03-13T21:21:00.723+00:00 The general recommendation applies: post CREATE TABLE statements for our tables together with INSERT statements with sample data and the desired result given the sample. We cannot copy anything from images. Nor can we read your mind to understand what you are looking for.
Sign in to comment -