I have the following tables:
item_category
- itemcat_id (int)
- type_id (int)
- itemcat_descr (varchar)
- display_order (varchar)
menuitem
- itemcat_id (int)
- menuitem_descr (varchar)
- menuitem_id (int)
- price (money)
menu_items
- menu_id (int)
- menuitem_id (int)
- display_order (int)
item_category.itemcat_id -> menuitem.itemcat_id
menuitem.menuitem_id -> menu_items.menuitem_id
I am trying to retrieve all items that match either MI.menuitem_id =
MIS.menuitem_id OR MI.menuitem_id IN (35,32,36,30,37,40,33,24,22,23) but I
am only getting the records that match on MI.menuitem_id = MIS.menuitem_id.
Any ideas why? TIA -> Duane
SELECT
IC.itemcat_id,
IC.type_id,
IC.itemcat_descr,
IC.display_order,
MI.menuitem_descr,
MI.menuitem_id,
MI.price
FROM (
item_category IC
INNER JOIN
menuitem MI ON IC.itemcat_id = MI.itemcat_id
AND MI.menuitem_id IN (35,32,36,30,37,40,33,24,22,23)
)
LEFT OUTER JOIN
menu_items MIS ON MI.menuitem_id = MIS.menuitem_id
WHERE
MIS.menu_id = 1
ORDER BY
IC.type_id,
IC.display_order,
IC.itemcat_id,
MIS.display_order,
MI.menuitem_descr
______________________________________________________________________
Why Share?
Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
