Client366
|
SQL help - 2008/05/24 08:10
Thought I'd post this for anyone in need of the sql data export query
| Code: |
SELECT
jos_users.name,
jos_users.email,
jos_emktg_list.list_name,
jos_emktg_list_user.listid,
jos_emktg_user.receive_html,
jos_emktg_user.confirmed,
jos_emktg_user.subscribe_date,
jos_emktg_user.unsubscribe_date
FROM jos_users
LEFT JOIN jos_emktg_list ON jos_emktg_list_user.listid= jos_emktg_list.listid
LEFT JOIN jos_emktg_list_user ON jos_users.id = jos_emktg_list_user.id
LEFT JOIN jos_emktg_user ON jos_users.id = jos_emktg_list_user.id
WHERE (
jos_users.id = jos_emktg_list_user.id && jos_emktg_list_user.id = jos_emktg_user.id
)
|
hth
|
Support