where clause
- Thread starter Mrwong
- Start date
Don
Is this a SQL where clause? If so we need more of the query and context as to what you are trying to achieve
Soldato
Assuming this is a SQL query, you define the columns to return in the select list, not the where clauses. The syntax would be something like this, but this query itself would be pretty useless:
As @Armageus said, some context or a code sample would help a lot here.
SQL:
SELECT
CONCAT([a], [b]) AS [c]
WHERE
[a] = [b]As @Armageus said, some context or a code sample would help a lot here.
Last edited:
It is for neo4j.
I have the relationships where by they are both independent each other, yet match them up to their respective groups. yet I want to only return the same names in the table.
So I have 4 nods that have no relationship to anything. One nodeA having a relationship to other nods. Get a list of the tables properties such as name or dob that contain key values which match with all the nods that are independent of any relationship and nodA.
Last edited:
the idea is find matches of mike that drives a red and blue car.
Also cars that do not have any relationships with a colour match's red or blue.
match (p : person {name: "Mike})-[:drives]->(b:Car)
where not : (b:car)--->p[r]--> ()
return p.name, b.colour, b.name
Last edited:
Soldato
If a=b then they are the same. Why do you need to return 2 things the same? Just return one of them (and you can name it C if you want but I don't see what difference that makes?)
Man of Honour
Semi serious, have you asked chatgpt?
Soldato
the idea is find matches of mike that drives a red and blue car.
Also cars that do not have any relationships with a colour match's red or blue.
match (p : person {name: "Mike})-[:drives]->(b:Car)
where not : (b:car)--->p[r]--> ()
return p.name, b.colour, b.name
In SQL you can do subqueries (not ideal but...) for the 'where not' but it sounds like it should be two separate queries - one for getting 'mikes' 'blue' and 'red' cars and then another for getting all cars that aren't red or blue that aren't a relationship to 'mike'.
Have you got a physical database structure (tables etc) for the data you're storing?
I am matching a list from two variables. To return a list that have the same key values leaving out key values they don't have in common.
Associate
This is possible in SQL without subqueries etc - you may have a better chance of getting an answer if you just post example data structure and what the end result you want. It's not 100% clear from your posts
Worked it out.
Man of Honour
Could you please explain how you resolved it? I say this for my past and future self, scrolling through countless forum posts about definitely common and simple issues that are declared solved without the solution posted
Could you please explain how you resolved it? I say this for my past and future self, scrolling through countless forum posts about definitely common and simple issues that are declared solved without the solution posted
Did not need to touch the where clause. By separating the relationships and creating New variable. It is cypher not SQL, Majority will not have used that yet.
Last edited: