Hi
I am having trouble to convert the following query with a sub query to use
a join, any advice I would be most grateful
Select Distinct portlet.* from portlet, portletAssignment PortletAssignment
where PortletAssignment.Group_FK in ('group1', 'group2')
AND portlet.name not in (
SELECT portlet_fk FROM UserTabAssignment WHERE user_fk = 'guest' AND
portal_FK = 'mysqlPortal' AND tabNumber = 0 AND subtabName =
'firstSubtab')
thanks
Alice Farbles
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
