Re: join two selects

On May 21, 4:54 pm, Tim Golden wrote: > gert wrote: > > I am trying to figure out how to join two selects ? > > > SELECT * FROM search > > SELECT eid, SUM(pnt) AS total_votes FROM vote > > > CREATE TABLE votes ( > >     eid  INTEGER PRIMARY KEY, > >

Re: join two selects

gert wrote: I am trying to figure out how to join two selects ? SELECT * FROM search SELECT eid, SUM(pnt) AS total_votes FROM vote CREATE TABLE votes ( eid INTEGER PRIMARY KEY, uid VARCHAR(64), pnt INETEGER DEFAULT 0, ); CREATE TABLE search ( eid INTEGER PRIMARY KEY

join two selects

I am trying to figure out how to join two selects ? SELECT * FROM search SELECT eid, SUM(pnt) AS total_votes FROM vote CREATE TABLE votes ( eid INTEGER PRIMARY KEY, uid VARCHAR(64), pnt INETEGER DEFAULT 0, ); CREATE TABLE search ( eid INTEGER PRIMARY KEY, txt VARCHAR(64