Hi, you may try:
SELECT DISTINCT portlet.*
FROM portletAssignment PortletAssignment,
portlet LEFT JOIN UserTabAssignment UTA
ON (portlet.name=UTA.portlet_fk AND UTA.user_fk = 'guest' AND
UTA.portal_FK = 'mysqlPortal' AND UTA.tabNumber = 0 AND
UTA.subtabName = 'firstSubtab'
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
