Displaying 2 results from an estimated 2 matches for "linked_site_id".
2009 Dec 18
6
SQL query problem
Please help me with finding a SQL select statement for the following
problems.
I have two classes: Site and Link
Table Link has two columns: linking_site_id, and linked_site_id
I would like to find all the links in table Link where linking_site_id
= 3 or linked_site_id = 3 but only include a link where linked_site_id
= 3 if the linking_site_id in that link is not one of the
linked_site_id that site 3 links to. For example, if the Link table
contains the followin...
2009 Dec 18
6
SQL query problem
Please help me with finding a SQL select statement for the following
problems.
I have two classes: Site and Link
Table Link has two columns: linking_site_id, and linked_site_id
I would like to find all the links in table Link where linking_site_id
= 3 or linked_site_id = 3 but only include a link where linked_site_id
= 3 if the linking_site_id in that link is not one of the
linked_site_id that site 3 links to. For example, if the Link table
contains the followin...