Originally posted by vamshi vamshi:
how to change it,can you explain please.
than you.
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Originally posted by vamshi vamshi:
there is no relation price and group_partner tables am just retrieving data using partnerid and eventid
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
SELECT
A.URL,
A.TITLE,
D.PARTNERID,
D.TICKET_NAME,
D.COMMISION ,
D.PRICE_ID,
D.EVENTID
FROM
GROUP_PARTNER A,
(SELECT
C.PARTNERID PARTNERID,
B.TICKET_NAME TICKET_NAME,
C.COMMISION COMMISION,
C.PRICE_ID PRICE_ID,
C.EVENTID EVENTID
FROM
PRICE B,
PARTNER_TICKET_COMMISION C
WHERE
C.PRICE_ID=B.PRICE_ID
AND
B.EVT_ID=C.EVENTID
AND
B.EVT_ID=43176.
) D
WHERE
A.PARTNERID = D.PARTNERID
AND
A.PARTNERID=3809
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Originally posted by vamshi g:
with out joining that two tables is there is any other way to restrict duplicates.
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Originally posted by vamshi g:
yes query is not workin
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Consider Paul's rocket mass heater. |