Kwang Chin Lee wrote:
> Hello,
>
> I have several tables storing item information, keyword (mainly for
> searching), category and subcategory (also for searching). The query I am
> using now is:
>
> SELECT i.*, it.*, ic.*, c.*, cs.*, s.*, st.* FROM item i
> LEFT JOIN iteminfo it ON i.id = it
Hello,
I have several tables storing item information, keyword (mainly for searching),
category and subcategory (also for searching). The query I am using now is:
SELECT i.*, it.*, ic.*, c.*, cs.*, s.*, st.* FROM item i
LEFT JOIN iteminfo it ON i.id = it.id
LEFT JOIN itemkeyword ik ON i.id = ik
