Is circular reference between 2 tables allowed
I have another question about circular references. I will use simplified example to illustrate my question.
Lets say I have the User table and the Comments table.
I have 2 use cases:
1- I want to get all the comments posted by user xyz
2- I want to get all the comments posted along with their Users (ie all the comments posted today and their user name)
I understand that I can achieve one of them by having a reference from one table to another.
Is it bad (or frawn upon) to have 2 ways relationship? I mean User table would have a column referencing the Comments table. And the Comments table would have a column referencing the user Table.
Theoritically, this way it should allow me to load any row with its relation.
Please let me know if you see any issues with this