Hi,

I want to join two tables. but there is no relationship between two like:

SELECT * FROM tblGroups inner join tblPermissions on tblGroups.Id= tblPermissions.EntityId AND tblPermissions.Type='Groups'

basically we are storing different entities permissions in the tblPermissions

Many thanks

Are you joining to filter the resultset, or to return fields from both tables, or both?

Thanks for your reply. I want to add this in my existing filter

Walaa wrote:

Are you joining to filter the resultset, or to return fields from both tables, or both?

Check this thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=17521