Databases
StackOverflow2013
Postsdbo
POOracle SQL how to write a sql statement that verifies if user in my network( ie friends or friend of friends)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POOracle SQL how to write a sql statement that verifies if user in my network( ie friends or friend of friends)
    primarykey
    data
    text
    <p>I have this problem. Given a <code>users</code> table that consists of users' username in a social network and <code>friends</code> table that contain a user's name and a user's friendname like below...</p> <pre><code>username friendname John Thomas Chris James </code></pre> <p>... I'm trying to write an SQL statement that will if a user is in my network. In other words is that user a friend or friend of friends?</p> <p>I've been dancing around this problem and could only come up with this query:</p> <pre><code>SELECT f2.username, f2.friendname FROM friends f2 WHERE f2.username IN ( SELECT f1.friendname FROM friends f1 WHERE f1.username = 'Thomas') AND f2.friendname &lt;&gt; 'user1' AND f2.friendname = 'user2'; </code></pre> <p>It basically check if a user if is a friend of my friend i.e. just return null if false.</p> <p>Trying to figure out how I can expand to go through all my network of friend. I mean not just friend of my friend.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAPC
    1. UScore_pro
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POOracle SQL how to write a sql statement that verifies if user in my network( ie friends or friend of friends)
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POOracle SQL how to write a sql statement that verifies if user in my network( ie friends or friend of friends)
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POOracle SQL how to write a sql statement that verifies if user in my network( ie friends or friend of friends)
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload