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