Does this work?
SELECT l.me_id AS me,
l.you_id AS you,
a.l AS left,
a.aspect,
a.r AS right,
l.id AS link_id,
c.comment,
concat(m.first_name, ' ', m.surname) AS me_name,
concat(y.first_name, ' ', y.surname) AS you_name
FROM aspects a,
On 01/04/2016 12:36 PM, gvim wrote:
I have a query which successfully retrieves id values "me" and "you"
when 2 planetary values are supplied:
SELECT l.me_id AS me, l.you_id AS you,
a.l AS left, a.aspect, a.r AS right, l.id AS link_id,
c.comment
FROM aspects a, links_aspects
I have a query which successfully retrieves id values "me" and "you"
when 2 planetary values are supplied:
SELECT l.me_id AS me, l.you_id AS you,
a.l AS left, a.aspect, a.r AS right, l.id AS link_id,
c.comment
FROM aspects a, links_aspects la, links l, syn_comments c
WHERE (a.r
