navid3d_69
یک شنبه 25 خرداد 1393, 17:29 عصر
سلام من این کوئری رو نوشتم درست هم کار می کنه فقط می خوام ببینم از نظر فنی و اصولی درست هست؟
SELECT b.blog,ac.access
FROM blog b
INNER JOIN author a
INNER JOIN blog_author ba
INNER JOIN author_access ac
WHERE b.blog = 'navid' AND
b.salt = 'xpjy8my078yznbqt1ttp9twb1aqnz10a' AND
a.salt = 'rzzt1yevhgpd1qca2zllicnwtftrtcyj' AND
a.id = 24 AND
ba.author_id = 24 AND
ba.blog = 'navid' AND
ac.author_id = 24 AND
ac.blog = 'navid'
SELECT b.blog,ac.access
FROM blog b
INNER JOIN author a
INNER JOIN blog_author ba
INNER JOIN author_access ac
WHERE b.blog = 'navid' AND
b.salt = 'xpjy8my078yznbqt1ttp9twb1aqnz10a' AND
a.salt = 'rzzt1yevhgpd1qca2zllicnwtftrtcyj' AND
a.id = 24 AND
ba.author_id = 24 AND
ba.blog = 'navid' AND
ac.author_id = 24 AND
ac.blog = 'navid'