That is just a simple outer join, then.
"*="
Don't work in iBatis, work in a sql query tool and hard code values
until you get what you want.
Also long term, "SQL for Smarties" (as opposed to Dummies) is a good book.
.V
Zoran Avtarovski wrote:
What I need is to retrieve a left join of a
Sorry Vic,
I'm not sure I understand.
I tried
SELECT list_item.value, list_item.label, m2m.trans_id
FROM list_item, m2m
WHERE list_item.list_type IN (?)
UNION
SELECT list_item.value, list_item.label, m2m.trans_id
FROM list_item
LEFT JOIN m2m ON
(m2m.response_id = list_item.value AND m2m.trans_id
I now have the need to store multiple list types in the list_item table
where x in (a, b, c)
and
have to add a list_type column to the list_item table.
select
union
select
.V
I've come across a stumbling point in my web app.
I used a left join in a previous app to get a list of items used to populate
a set of check box items and to see if they were checked.
eg
SELECT list_item.value, list_item.label, m2m.trans_id
FROM list_item
LEFT_JOIN m2m ON
(m2m.response_id = list
