1 (edited by d4mn 2009-05-15 13:04:38)

Topic: Uzklausa is triju lenteliu

Sveiki, nesusitvarkau su uzklausa is triju lenteliu pagrindine (url) sekanti (campaign) kuri joininasi su (campaing_urls) pagal where campaign.id = campaign_urls.cmp_id o url left joinina su siom abiejom lentelem mano bandymas:

SELECT * FROM urls AS u left join 
(SELECT * FROM campaign AS cmp join campaign_urls AS cmp_url on cmp.id=cmp_url.cmp_id) 
where cmp.id=2 AND u.userid=1 AND u.active=1

any help?


Susitvarkiau siaip ne taip

SELECT *
FROM (
`urls`
)
LEFT JOIN `campaign_urls` ON `urls`.`id` = `campaign_urls`.`url_id`
AND `campaign_urls`.`cmp_id` = '2'
WHERE `userid` = '1'
AND `active` = '1'
LIMIT 0 , 30